sql server 2005 two instances - same server *Mssqlserver* and *DEV* share db including USER accounts between them.

I need to copy a set of db's over to a second sql server instance and NOT have any of the security lost - if I was going to a instance on another server i would bring the system databases with and take care of the problem.  I know someone that said they had a script but now they said they can't find it.

PLEASE help
MyDanesAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
SireesConnect With a Mentor Commented:
Check is this one helps

http://support.microsoft.com/kb/918992/
0
All Courses

From novice to tech pro — start learning today.