InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 01:01:36 GMT20http://www.sqlservercentral.com/Forums/Topic1234131-1292-1.aspxMaybe not, but you could always do it the other way round.Fri, 13 Jan 2012 09:45:47 GMTspaghettidbahttp://www.sqlservercentral.com/Forums/Topic1234131-1292-1.aspxIs it a good Idea to link Production server to Test server?Fri, 13 Jan 2012 09:40:42 GMTDBA_Learnerhttp://www.sqlservercentral.com/Forums/Topic1234131-1292-1.aspxThank you.Fri, 13 Jan 2012 09:40:12 GMTDBA_Learnerhttp://www.sqlservercentral.com/Forums/Topic1234131-1292-1.aspxA third option is to use PowerShell. I'm not a PowerShell guy myself, but I think this is an excellent scenario for using it.Thu, 12 Jan 2012 08:41:09 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic1234131-1292-1.aspxAnother option: use a linked server.Wed, 11 Jan 2012 10:42:50 GMTspaghettidbahttp://www.sqlservercentral.com/Forums/Topic1234131-1292-1.aspxSure you can, but you have a little work to do.This query lists users per database :sp_MSForeachdb 'USE ?select db_name() as dbname , sp.name as login , dp.name as [user]from sys.database_principals dpinner join sys.server_principals sp on sp.principal_id = dp.principal_idWHERE dp.type_desc = ''SQL_USER'''Run it on your test and prod server and then :- compare with Excel for eample- import your prod users to your dev server (you will have to store the results in a table and then use Import Data wizard in Management Studio)and compare with a FULL JOINWed, 11 Jan 2012 09:56:40 GMTazdznhttp://www.sqlservercentral.com/Forums/Topic1234131-1292-1.aspxCan we compare users between two servers, for ex: users in production and test environments to see users in the Test Environment that are not in production and inactive Production users that are active in the Test environment.Wed, 11 Jan 2012 09:39:38 GMTDBA_Learner