February 19, 2008 at 12:35 pm
I'm looking for a script to help grab the server (instance) characteristics. Basically, what I'd ideally like to collect is everything (or as much as possible) from the 9 tabs under RightClick(ServerName)
->Properties. Does anyone have such a tool already created and is willing to share? Or can you point to a few specific tables or stored procs that would help in my quest? I'm at a new company and have 20+ servers that I'd like to document, easily 😀 if possible (of course!) and any suggestions would be greatly appreciated. Thanks.
-- You can't be late until you show up.
February 19, 2008 at 2:01 pm
Have you looked at the SQL Server Health and History tool provided by MS for nothing?
I believe it will gather all the information for you. You can also get some pre-designed SSRS reports for SQLH2.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 19, 2008 at 2:10 pm
Sorry, I thought these only pertained to SQL 2005. I used these at my last company which had several 2005 installations and for freebies, thought they were great starting points for some cool documentation (if there is such a thing!). My fault for not stating we're on SQL 2000, sp4 at my new place of employment.
-- You can't be late until you show up.
February 19, 2008 at 2:17 pm
I actually used this for SQL2000 and SQL 7 (some of the features work) at my last employer. It was actually released before SQL2005.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 19, 2008 at 2:20 pm
Cool, thanks. I was just going to download it. I appreciate the quick responses.
-- You can't be late until you show up.
February 20, 2008 at 10:09 am
DOH! sp_configure returns all the characteristics of SQL. Amazing how much your mind begins to atrophy when your not using the tools!
-- You can't be late until you show up.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply