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

SQL Server System Report Expand / Collapse
Author
Message
Posted Friday, November 19, 2010 11:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 14, 2014 12:28 PM
Points: 16, Visits: 292
Hey Sean,

This is an excellent script and I am happy to use it.

Our environment does not allow any email format but plain text. I been messing with the script, trying to create an attached (html) file but have little luck (except to rewrite the code, drop each result in a table and then bcp it as a file to be attached) which results in html formatting code being placed where values need to be.

Have you though of doing this yourself?
Post #1023709
Posted Friday, November 19, 2010 2:34 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
Hmm... interesting issue. I haven't tried, but I may have taken the approach of writing the results out to a file (HTML tags included) into a text file, but name it something like "my_results.html" and then send a text email with the file as an attachment. Let me know if that makes sense.
Post #1023832
Posted Friday, January 27, 2012 7:36 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
Some new changes coming very soon to this script! :)

"Last Backup Set Details" Section Will Only Show Information For Databases Currently On The Instance

Added "@v_Output_Mode" Input Parameter (you can select if you want the results to be displayed on-screen or via e-mail now!)

Added "backup_finish_date", "database_version", "machine_name", And "server_name" To "Last Backup Set Details" Section

Added "connections", "first_day_of_week", "is_clustered", And "windows_version" To "Server Instance Property Information" Section

Added "create_date" And "file_name" To "Database Recovery Model / Compatibility / Size (Detailed) / Growth Stats" Section

Added "schema_name" To "Unused Indexes" Section

Extended "CONVERT" Character Length To Deal With "Msg 234" Error

Rewrote Time Calculation Logic, Code Restructuring For Better Query Performance & Minor Changes To Code Style

Sean
Post #1242853
Posted Tuesday, September 4, 2012 8:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 27, 2014 8:39 AM
Points: 22, Visits: 64
I've been using this report quite happily for well over a year now on 3 of my servers. However, on one of them it has started failng with the error below. Any ideas? I should add that I recently upgraded from 2005 to 2008R2 but it was working fine for a couple of weeks after that.

Executed as user: Domain\username. There is insufficient result space to convert a money value to varchar. [SQLSTATE 22003] (Error 234). The step failed.
Post #1353902
Posted Tuesday, September 4, 2012 8:16 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
There were some changes to the script recently. Do you have the latest one?
Post #1353917
Posted Tuesday, September 4, 2012 8:18 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, December 18, 2014 8:10 AM
Points: 51, Visits: 410
and where is the best place to get the most current script?

SQL_Padre
aka Robert M Bishop

"Do or do not, there is no try" -- Yoda
Post #1353922
Posted Tuesday, September 4, 2012 8:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 27, 2014 8:39 AM
Points: 22, Visits: 64
No I don't. Do you think it will solve the problem?
Post #1353923
Posted Tuesday, September 4, 2012 8:20 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
It might, or at the least be easier to trouble shoot. The latest version is the one currently posted on SSC.com:

http://www.sqlservercentral.com/scripts/Administration/70243/
Post #1353926
Posted Tuesday, September 4, 2012 8:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 27, 2014 8:39 AM
Points: 22, Visits: 64
On closer inspection I think I probably do have the latest - I created the report on 6/7/2010. How could I tell for sure?
Post #1353953
Posted Tuesday, September 4, 2012 9:19 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
Do you have the "@v_Output_Mode" parameter in the script?
Post #1353988
« Prev Topic | Next Topic »

Add to briefcase «««56789»»»

Permissions Expand / Collapse