Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 sysadmin users

Author  Topic 

ksr39
Posting Yak Master

193 Posts

Posted - 2011-10-07 : 15:18:40
Hi All,

Every time Im logging into servers and getting the information of the users who are having sysadmin permissions. we are having 100 servers on different different domains’ trying to locate one centralized server and connect all the servers to it and run a script but Im unable to get it can any one help me in getting the script.
i will be very much thankful to you...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-07 : 15:46:13
Do you have access to a SQL 2008 system? If so, you can use the CMS to run a query against all of them and return it in one result set.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2011-10-09 : 02:55:39
Maybe powershell can help you.Have a look here

http://www.simple-talk.com/sql/database-administration/let-powershell-do-an-inventory-of-your-servers/

PBUH

Go to Top of Page
   

- Advertisement -