View Single Post
  #3 (permalink)  
Old January 24th, 2005, 07:30 AM
jemacc jemacc is offline
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

In addition to madhukp suggestions, you should also moved your user accounts and security, dts. etc. since you will have a different master database on your new server the accounts will not be mapped to the correct logins (sids)

See SQL Server Books Online to get more information about the sp_change_users_login stored procedure.

http://support.microsoft.com/kb/246133

Jaime E. Maccou
Reply With Quote