September 12, 2013 at 1:28 pm
Hi, Joe.
I just realized that this uses an undocumented feature. I already have one in the script and I try to avoid them like the plague (just in case!). I am going to leave it out of the script and let people to choose whether or not to use it on their own. Sorry about that! 🙂
joe.eager (8/28/2013)
I added in the ability to show errors/failures in the SQL Error Log for the last 24 hours if anyone is interested.
September 12, 2013 at 1:30 pm
Sean Smith-776614 (9/12/2013)
Hi, Joe.I just realized that this uses an undocumented feature. I already have one in the script and I try to avoid them like the plague (just in case!). I am going to leave it out of the script and let people to choose whether or not to use it on their own. Sorry about that! 🙂
joe.eager (8/28/2013)
I added in the ability to show errors/failures in the SQL Error Log for the last 24 hours if anyone is interested.
Not a problem. Thanks
September 13, 2013 at 6:34 am
Okay, latest changes are almost done. Still have more ideas but I at least want to get something posted ASAP. Here are the upcoming changes:
Reformatted the code
Bug fixes
Moved the @Recipients and @Copy_Recipients variables to be input parameters
Renamed input parameters
Added new input parameters to easily include / exclude various sections of the report:
@Server_Instance
@Server_Settings
@Drives_Space
@Database_Summary
@Database_Details
@Last_Backup
@Agent_Jobs
@Fragmentation
@Missing_Indexes
@Unused_Indexes
Added new sections:
Server Settings
First Day Of Week
Collation
Case Sensitive
Full-Text Installed
Advanced Options Enabled
CLR Enabled
Command Shell Enabled
Database Mail Enabled
Default Trace Enabled
Minimum Memory (MB)
Maximum Memory (MB)
Index Fragmentation
Database Name
Schema Name
Object Name
Column Name
Index Name
Fragmentation
Index Type
PK
Unique
Recommendation
Alter Index Statement
Missing Indexes
Database Name
Schema Name
Object Name
Unique Compiles
User Seeks
User Scans
Avg User Cost
Avg User Impact
Overall Impact
Impact Rank
Index Column(s)
Include Column(s)
Table Column Count
Index Column Count
Include Column Count
Index % Of Columns
Include % Of Columns
Total % Of Columns
Create Index Statement
Moved one element from Server Instance Property Information section and added new output:
Process ID
Logical CPU Count
Physical CPU Count
Just need to update the article and post. 🙂
Thanks everyone for your feedback and encouragement!
Sean
September 20, 2013 at 10:17 am
New version submitted. Should take a few days for the folks at SSC.com to review / approve and then the new code and details will be live. 🙂
September 23, 2013 at 10:42 am
The new version is live! 🙂
September 25, 2013 at 3:36 pm
Hi Sean, The new version is better than ever!
I have made a change that I thought would be helpful to me and possibly others as well so I thought I would share it here? I have added the Database Owner for each database to Main Query V and the Job Owner for each job to Main Query VII. I have attached the code changes I made for each section if anyone would like to use it? Just replace the entire section of code with the appropriate attachment. I have tested it on 2005 and 2008R2
September 25, 2013 at 4:31 pm
Oh wow, this is a great idea! I never even thought about it! D'oh!!! Mind if I officially add it to the script?
September 26, 2013 at 7:48 am
Sure, I am glad you liked the idea!
September 26, 2013 at 8:05 am
Great! Thanks so much for sharing the idea and code! 🙂
September 27, 2013 at 6:48 am
Sean, This is likely a stupid question,but where is the new code? Is it back on the original post? Thanks.
Lee
September 27, 2013 at 6:56 am
Yes, the original post has been updated with the new code and article. 🙂
http://www.sqlservercentral.com/scripts/Administration/70243/
Sean
September 27, 2013 at 6:57 am
Thank you Sean.
September 27, 2013 at 7:22 am
No problem. 🙂
October 14, 2013 at 2:52 am
Hi
doesnt seem to support mounted volumes, will you be addressing this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 14, 2013 at 7:11 am
Hi Sean,
I like your script.
What about some more instance property information - I mean something like this:
...
,instance_name =
CASE
WHEN SERVERPROPERTY (N'InstanceName') IS NULL THEN 'Default Instance'
ELSE SERVERPROPERTY (N'InstanceName')
END
, @@LANGUAGE as [Language]
, right(substring(@@version,charindex(' - ',@@version)+17,PATINDEX('%Copyright%',@@version)-27-(charindex(' - ',@@version)+17)),3) as [32|64]
,(CASE WHEN CONVERT(CHAR(30), Serverproperty('ISIntegratedSecurityOnly')) = 1
THEN 'Integrated Security '
WHEN CONVERT(CHAR(30), Serverproperty('ISIntegratedSecurityOnly')) = 0
THEN 'SQL Server Security '
ELSE 'INVALID INPUT/ERROR'
END) AS 'SECURITY',
CU
tosc
[font="Verdana"]CU
tosc[/font]
Viewing 15 posts - 121 through 135 (of 189 total)
You must be logged in to reply to this topic. Login to reply