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
 SQL Server Administration (2005)
 Is there anyway to get SServer 2005 configuration?

Author  Topic 

daimne
Starting Member

17 Posts

Posted - 2008-10-06 : 18:29:16
have multiple more than 50 of 2000 and 2005 servers
What is the fastest way to collect servers configuration?

TIA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-06 : 18:33:26
You can send your queries through sqlcmd. But what configuration items did you want to see?

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

Subscribe to my blog
Go to Top of Page

daimne
Starting Member

17 Posts

Posted - 2008-10-07 : 12:41:00
Thank you for your response.
We are looking for general info on the server like: version, service pack, list of the databases, may be few vital server parameters...
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-07 : 12:43:34
Have a look at this tool: http://weblogs.sqlteam.com/tarad/archive/2008/06/11/Ideras-SQL-admin-toolset.aspx

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

Subscribe to my blog
Go to Top of Page
   

- Advertisement -