Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 import exsisting database with users

Author  Topic 

magmo
Aged Yak Warrior

558 Posts

Posted - 2010-06-10 : 05:37:33
Hi

I have a sql server 2000 database backup file (*.trn fil) that I need to restore to a sql server 2008. The database have users and permissions set on stored procedures and tables. How do I proceed to gat all permissions and users to the new database without the need to manualy set all permissions and add the users?
   

- Advertisement -