What is AD that your refering to?

Ask your system administrator (not DBA) to create an account in AD and set expiration time;

You assign this (windows) account in SQL Server with...

I am using SQL 2000. So what should I first?

Here is what I found.

Script out the existing persmissions. Run the command. Reapply the script and...

Some objects are owned by these db_owner that have left. How can I transfer these objects to the dbo?

O.k i did the script and run it against the second databse. It created an empty table. I will try the wizard right now.

But that erase the primary key and...

Ya of course your right the data is not the same.

What do you mean by scripting out?

Another question:

How do I copy a table from one database to another on the same server?

Without losing the dependency and keys?

what is DTS or SSIS wizard?

There is no error message. I am trying to find a way to restore a database without overwriting some tables. The reason is our users entered test data...