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 2005 Forums
 SQL Server Administration (2005)
 Transfer usero n another server

Author  Topic 

JaiVerma2k2
Starting Member

3 Posts

Posted - 2010-06-04 : 16:32:02
We are running on SQL 2005. how to transfer all sql server users with their permission and all jobs to other SQL 2005 server.
please advise

Regards
Jai Verma

Sommerville
Starting Member

4 Posts

Posted - 2010-06-04 : 23:22:40
You can create an SSIS Package- if you want it for one time. If you want it to happen everyday - you need to write some script for it.

regards,
Sommerville
Go to Top of Page
   

- Advertisement -