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 8 of 9

«««5 6 7 8 9 »»

SQL Server System Report

Rate Topic

Display Mode

Topic Options

Author

Message

george25

Posted Wednesday, September 05, 2012 3:12 AM

Grasshopper

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

No I don't. Does this mean it's not the latest version?

Post #1354392

george25

Posted Wednesday, September 05, 2012 9:29 AM

Grasshopper

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

I've made a bit of a hash of this I'm afraid. Firstly I ran the latest script ok but had problems getting my scheduled job to work .......... so I deleted the old sp and the new one and tried running the new script again but when I do I get the error shown below. Please help.

Msg 102, Level 15, State 1, Line 49
Incorrect syntax near 'Calculation'.
Msg 111, Level 15, State 1, Line 67
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.

Post #1354672

Sean Smith-776614

Posted Wednesday, September 05, 2012 9:33 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 90, Visits: 369

Okay, copy the script in full from this site and run it in the appropriate database (don't do anything past that point). Let me know if it at least creates the proc properly.

Post #1354676

george25

Posted Wednesday, September 05, 2012 9:53 AM

Grasshopper

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

Thanks that works however, I'm still not getting the report via email when I run my SQL job. Database mail is working. Is the only line I need to change SET @vRecipients? Thanks for your patience.

Post #1354702

george25

Posted Wednesday, September 05, 2012 10:03 AM

Grasshopper

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

Doh! Hadn't set the output mode to E. It all works fine now. Thanks again

Post #1354713

Sean Smith-776614

Posted Wednesday, September 05, 2012 10:20 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 90, Visits: 369

Fantastic. Hope you enjoy some of the new features of this version. :)

Post #1354728

missionrestart

Posted Wednesday, September 12, 2012 1:24 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 6:16 AM
Points: 41, Visits: 298

Hi Sean,

U have done a fantastic job designing a script which will give entire server report. But , is there any possibility, to save the report to local disk in the form of some html report?

Post #1357815

Sean Smith-776614

Posted Wednesday, September 12, 2012 5:29 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 90, Visits: 369

There are various methods of saving output to a file. Unfortunately it is too long to go into detail here, but if you Google "SQL Server saving results to a file" you should be able to find some good articles to help you out. I've noted the idea as it is a good one and I will likely add it as an option when I do my next update of the code to allow for saving of the data to HTML, text, CSV, etc.

Post #1357906