Moving SQL Server Components

From: Larry (Larry_at_discussions.microsoft.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 07:31:09 -0700

Hi Everyone,

We have a new dedicated server for SQL operations. I'm moving all of the objects over to the new server: databases, jobs, alerts, operators, logins. While testing the transfer, I noticed that the logins do not have the access to the databases and roles are not set. Considering I used the stored procedure in KB article 246133, it should have kept the same database accesses and db roles. Any ideas on this one?

Should I be moving these objects in a specific order for more accurate and optimal results? Does it make a difference?

Thanks in advance.

Larry

Loading