Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

SQL Server System Report Expand / Collapse
Author
Message
Posted Thursday, June 17, 2010 6:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:20 AM
Points: 343, Visits: 697
Fantastic! Great to hear. :)
Post #938840
Posted Thursday, June 17, 2010 7:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 6:39 AM
Points: 13, Visits: 490
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
Posted Thursday, June 17, 2010 7:30 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:20 AM
Points: 343, Visits: 697
Hmmm... would need to see the output. Send it to me if you want (email address is in the script).
Post #938894
Posted Thursday, June 17, 2010 11:49 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 10:38 PM
Points: 5, Visits: 30
This the report I've been looking for all my life. Thank you!

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
Posted Thursday, June 17, 2010 11:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:20 AM
Points: 343, Visits: 697
Sorry, there is no 2000 version (and unlikely that I'll be making one).
Post #939150
Posted Thursday, June 17, 2010 12:00 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 10:38 PM
Points: 5, Visits: 30

Alright..

Thanks anyways, the sql2005 report is great.
Post #939153
Posted Friday, June 18, 2010 8:16 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:16 PM
Points: 990, Visits: 2,223
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
Posted Friday, June 18, 2010 8:35 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:20 AM
Points: 343, Visits: 697
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
Posted Monday, June 21, 2010 7:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 28, 2011 6:36 AM
Points: 1, Visits: 15
I'm having the same issue... did you get a response to this?
Post #940303
Posted Tuesday, June 22, 2010 9:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 7:16 AM
Points: 1, Visits: 12
Thank you, your script is much appreciate.
Post #941134
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse