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 Saturday, May 15, 2010 4:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:54 PM
Points: 314, Visits: 583
Comments posted to this topic are about the item SQL Server System Report
Post #922456
Posted Monday, May 24, 2010 11:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 7:13 AM
Points: 108, Visits: 192
Great script!! Very uself....
Post #926972
Posted Monday, May 24, 2010 11:03 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:54 PM
Points: 314, Visits: 583
Thank you! I hope it helps you out. :)
Post #926973
Posted Monday, June 14, 2010 5:05 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 19, 2013 11:53 AM
Points: 17, Visits: 559
Hi, love this script! Thanks for taking the time to put this together!
This is coming to come in handly often. Thanks again
Post #937184
Posted Thursday, June 17, 2010 5:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:48 AM
Points: 21, Visits: 63
Sean

I've tried your script but get a whole load of errors (see below). I'd be grateful for your help as your report looks really useful.

Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 29
Line 29: Incorrect syntax near 'MAX'.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 30
Line 30: Incorrect syntax near 'MAX'.
Msg 156, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 37
Incorrect syntax near the keyword 'TABLE'.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 39
Line 39: Incorrect syntax near 'MAX'.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 40
Line 40: Incorrect syntax near 'MAX'.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 41
Line 41: Incorrect syntax near 'MAX'.
Msg 137, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 45
Must declare the variable '@vRecipients'.
Msg 137, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 46
Must declare the variable '@vCopy_Recipients'.
Msg 137, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 62
Must declare the variable '@vXML_String'.
Msg 137, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 69
Must declare the variable '@vBody'.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 145
Line 145: Incorrect syntax near 'MAX'.
Msg 156, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 159
Incorrect syntax near the keyword 'FOR'.
Msg 137, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 185
Must declare the variable '@vBody'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 185
Must declare the variable '@vBody'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 213
Must declare the variable '@vFixed_Drives_Free_Space_Table'.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 228
Line 228: Incorrect syntax near 'MAX'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 234
Must declare the variable '@vFixed_Drives_Free_Space_Table'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 243
Must declare the variable '@vBody'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 257
Must declare the variable '@vBody'.
Msg 137, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 345
Must declare the variable '@vSQL_String'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 345
Must declare the variable '@vSQL_String'.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 363
Line 363: Incorrect syntax near 'MAX'.
Msg 156, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 375
Incorrect syntax near the keyword 'ORDER'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 383
Must declare the variable '@vBody'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 402
Must declare the variable '@vBody'.
Msg 195, Level 15, State 10, Procedure usp_SSAJ_SQL_Server_System_Report, Line 443
'ROW_NUMBER' is not a recognized function name.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 468
Line 468: Incorrect syntax near 'MAX'.
Msg 156, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 489
Incorrect syntax near the keyword 'ORDER'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 498
Must declare the variable '@vBody'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 517
Must declare the variable '@vBody'.
Msg 195, Level 15, State 10, Procedure usp_SSAJ_SQL_Server_System_Report, Line 563
'ROW_NUMBER' is not a recognized function name.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 584
Line 584: Incorrect syntax near 'A'.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 597
Line 597: Incorrect syntax near 'MAX'.
Msg 156, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 612
Incorrect syntax near the keyword 'ORDER'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 621
Must declare the variable '@vBody'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 640
Must declare the variable '@vBody'.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 723
Line 723: Incorrect syntax near 'MAX'.
Msg 156, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 734
Incorrect syntax near the keyword 'ORDER'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 742
Must declare the variable '@vBody'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 760
Must declare the variable '@vBody'.
Msg 137, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 877
Must declare the variable '@vSQL_String'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 877
Must declare the variable '@vSQL_String'.
Msg 170, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 895
Line 895: Incorrect syntax near 'MAX'.
Msg 156, Level 15, State 1, Procedure usp_SSAJ_SQL_Server_System_Report, Line 907
Incorrect syntax near the keyword 'ORDER'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 918
Must declare the variable '@vBody'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 937
Must declare the variable '@vBody'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 971
Must declare the variable '@vBody'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 979
Must declare the variable '@vBody'.
Msg 137, Level 15, State 2, Procedure usp_SSAJ_SQL_Server_System_Report, Line 988
Must declare the variable '@vRecipients'.
Post #938806
Posted Thursday, June 17, 2010 6:16 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:54 PM
Points: 314, Visits: 583
My pleasure! :)
Post #938828
Posted Thursday, June 17, 2010 6:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:54 PM
Points: 314, Visits: 583
Can you give me some details such as what version of SQL Server you are using? Also, I know that if you are using some versions of IE that code on SQLServerCentral doesn't always copy / paste properly.
Post #938831
Posted Thursday, June 17, 2010 6:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 12:51 PM
Points: 86, Visits: 88
Love the article. However it's going to talk a lot of work to make it Binary compatible. Unfortunately due to the nature of the beast we run all our DBMS in Latin1_Gen_Binary. As such, spelling and capitalization matter.

I always hate when really great articles end up in hours of frustration trying to retrofit the solution into Binary format.

Great article...
Post #938832
Posted Thursday, June 17, 2010 6:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:54 PM
Points: 314, Visits: 583
Thanks for the feedback. Sorry it can't help you though.
Post #938834
Posted Thursday, June 17, 2010 6:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 12:51 PM
Points: 86, Visits: 88
Actually, I appologize. It was only 3 places with SYSNAME vs sysname.

Really Cool...
Post #938835
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse