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 helpStart Free Trial