SQL Server System Report

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sean Smith » SQL Server System Report

84 posts, Page 2 of 9

««1 2 3 4 5 »»»

SQL Server System Report

Rate Topic

Display Mode

Topic Options

Author

Message

Sean Smith-776614

Posted Thursday, June 17, 2010 6:27 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

Fantastic! Great to hear. :)

Post #938840

Alphonse

Posted Thursday, June 17, 2010 7:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 2:46 PM
Points: 7, Visits: 414

Great article. Fits in with a project that I am working on.
Just to try it out, I ran as script on my development machine (SQL Server 2005) without creating the proc and output the body content to text or a file.
The output is greatly truncated at the Database Recovery Model section. Maybe some nulls getting concatenated somewhere?

Post #938889

Sean Smith-776614

Posted Thursday, June 17, 2010 7:30 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

Hmmm... would need to see the output. Send it to me if you want (email address is in the script).

Post #938894

ArthurEM1

Posted Thursday, June 17, 2010 11:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 06, 2012 7:54 PM
Points: 5, Visits: 28

This the report I've been looking for all my life. Thank you! Smile

Just one little thing, it runs terrific on SQL2005 but not at all on SQL2000. Is it possible that you might have SQL2000 version???

Thanks again, I can really use this report.

Post #939146

Sean Smith-776614

Posted Thursday, June 17, 2010 11:53 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

Sorry, there is no 2000 version (and unlikely that I'll be making one).

Post #939150

ArthurEM1

Posted Thursday, June 17, 2010 12:00 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 06, 2012 7:54 PM
Points: 5, Visits: 28

Alright..

Thanks anyways, the sql2005 report is great.

Post #939153

rVadim

Posted Friday, June 18, 2010 8:16 AM

SSC Eights!

Group: General Forum Members
Last Login: Sunday, May 19, 2013 1:36 PM
Points: 887, Visits: 2,062

Great script - Thank you very much!

Couple of suggestions:

1. In List Backup Set Details it seems to be reporting databases that were deleted as well as those that are currently off line. It would be nice to have ability to filter those off.

2. In the Unused Indexes it would be nice to have Schema name along with Table name.

Thank you,
--Vadim.

Post #939627

Sean Smith-776614

Posted Friday, June 18, 2010 8:35 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

Great suggestions. For point 1 I noticed this as well but still wanted to see them for my purposes (plus they fall off the list as we do cleanups of the history tables). For point 2, there is the schema name in the drop index statement. For both points, I have added them in my "to do" list for the next release. Thanks!

Post #939647