drop and re-create table

What kind of problems may I see if a process drop and re-create a set of
tables every night?A Biggy: You will lose all access permissions that have been set for the
tables -unless you add steps to recreate the permissions on the tables.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:801C90E1-5D1B-4171-8B49-CCAFF38563FC@.microsoft.com...
> What kind of problems may I see if a process drop and re-create a set of
> tables every night?
>|||JIM.H. wrote:
> What kind of problems may I see if a process drop and re-create a set of
> tables every night?
>
Why not just TRUNCATE them?
Tracy McKibben
MCDBA
http://www.realsqlguy.com