I am trying to purge a database of data over 13 months
old. I can easily move the old data to an archive table
and the new data to a transfer table. Management wants
the table dropped and recreated before transfering the
data back so indexing can be recreated and any other
problems removed. I created a script to drop and
recreate the database in EM and pasted it into a SQL Task
in DTS. The problem is that the package does not
recreate the users in the database and the domains users
suddenly have no rights to the new database. Any ideas
on how to get around this small problem? Why doesn't the
SQL script from EM create users in the new database with
rights matching their rights in the dropped database?

Randy

The scripting facility in EM will recreate users in the DB and their object
level permissions.

Last tab (Options)

I do not know why you need to drop and recreate the tables to achieve your
aim here. You can issue reindex statements after removing the records.

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Randy Gill" <rgill (AT) sumitomotrustusa (DOT) com> wrote