<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
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 1 of 9
1
2
3
4
5
»
»»
SQL Server System Report
Rate Topic
Display Mode
Topic Options
Author
Message
Sean Smith-776614
Sean Smith-776614
Posted Saturday, May 15, 2010 4:18 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:56 PM
Points: 93,
Visits: 380
Comments posted to this topic are about the item
SQL Server System Report
Post #922456
HextallFanForLife
HextallFanForLife
Posted Monday, May 24, 2010 11:01 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 1:19 PM
Points: 106,
Visits: 165
Great script!! Very uself....
Post #926972
Sean Smith-776614
Sean Smith-776614
Posted Monday, May 24, 2010 11:03 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:56 PM
Points: 93,
Visits: 380
Thank you! I hope it helps you out. :)
Post #926973
amc-885860
amc-885860
Posted Monday, June 14, 2010 5:05 PM
Grasshopper
Group: General Forum Members
Last Login: Friday, May 31, 2013 10:55 AM
Points: 16,
Visits: 558
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
george25
george25
Posted Thursday, June 17, 2010 5:25 AM
Grasshopper
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
Sean Smith-776614
Sean Smith-776614
Posted Thursday, June 17, 2010 6:16 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:56 PM
Points: 93,
Visits: 380
My pleasure! :)
Post #938828
Sean Smith-776614
Sean Smith-776614
Posted Thursday, June 17, 2010 6:17 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:56 PM
Points: 93,
Visits: 380
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
mlabedz
mlabedz
Posted Thursday, June 17, 2010 6:17 AM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, September 11, 2012 7:57 AM
Points: 86,
Visits: 87
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
Sean Smith-776614
Sean Smith-776614
Posted Thursday, June 17, 2010 6:20 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 14, 2013 2:56 PM
Points: 93,
Visits: 380
Thanks for the feedback. Sorry it can't help you though.
Post #938834
mlabedz
mlabedz
Posted Thursday, June 17, 2010 6:23 AM
SSC Journeyman
Group: General Forum Members
Last Login: Tuesday, September 11, 2012 7:57 AM
Points: 86,
Visits: 87
Actually, I appologize. It was only 3 places with SYSNAME vs sysname.
Really Cool...
Post #938835
« Prev Topic
|
Next Topic »
84 posts, Page 1 of 9
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
