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 «««678910»»»

SQL Server System Report Expand / Collapse
Author
Message
Posted Wednesday, September 5, 2012 3:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, September 5, 2012 9:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, September 5, 2012 9:33 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 6:08 AM
Points: 341, Visits: 689
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
Posted Wednesday, September 5, 2012 9:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, September 5, 2012 10:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, September 5, 2012 10:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 6:08 AM
Points: 341, Visits: 689
Fantastic. Hope you enjoy some of the new features of this version. :)
Post #1354728
Posted Wednesday, September 12, 2012 1:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, June 1, 2014 11:54 PM
Points: 46, Visits: 355
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
Posted Wednesday, September 12, 2012 5:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 6:08 AM
Points: 341, Visits: 689
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
Posted Wednesday, September 12, 2012 10:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:48 AM
Points: 21, Visits: 63
Not sure if this meets your requirement but if you choose the option to send the report by email the recipient can then save it manually.
Post #1358097
Posted Wednesday, September 12, 2012 10:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 6:08 AM
Points: 341, Visits: 689
Actually, that is a decent workaround for now. :)
Post #1358128
« Prev Topic | Next Topic »

Add to briefcase «««678910»»»

Permissions Expand / Collapse