SQLServerCentral / Discuss content posted by Rudy Panigas / Article Discussions / Article Discussions by Author / SQL Server Documentor / Latest Posts

RE: SQL Server Documentor

KWymore — Wed, 02 Jan 2013 18:43:02 GMT

Nice script Rudy. Thanks to Lee and WDolby for their recommended fixes too.

RE: SQL Server Documentor

chvreddy78 — Tue, 25 Dec 2012 22:22:29 GMT

hi very good script

RE: SQL Server Documentor

Rudy Panigas — Wed, 12 Dec 2012 06:48:04 GMT

Hello Everyone,I have just updated the script to have the 7) and 8) comments reversed. Sorry about that and the delays to get it corrected. The update should be on the site soon.Thanks,Rudy :-)

RE: SQL Server Documentor

jasona.work — Tue, 11 Dec 2012 14:53:43 GMT

Just gave this a try, and love it!Did notice one quirk though.Section 7) Last backup dates and section 8) List of SQL jobs are flip-flopped.Section 7 claims to be the last backup dates, but instead gives the list of SQL Jobs, and 8) gives the list of Last backup dates.Jason

RE: SQL Server Documentor

Rudy Panigas — Tue, 27 Nov 2012 12:48:06 GMT

Thanks again to everyone for the improvements :-)Rudy

RE: SQL Server Documentor

wdolby — Tue, 20 Nov 2012 12:22:04 GMT

Great script. I noticed not all of my databases were showing under --> Database(s) Details <--. The join is using name and several of my databases have logical names that don't match the actual database name. I changed the join condition to use database_id and filtered out the extra rows by looking only for the primary file.--> Database(s) Details <--SELECT...INTO #Databases_DetailsFROM SYS.DATABASES DINNER JOIN sys.master_files SON D.database_id= S.database_idWHERE s.file_id = 1

RE: SQL Server Documentor

Rudy Panigas — Mon, 19 Nov 2012 12:43:54 GMT

Hello Lee,Thanks for the update. Sorry about that, it not always easy to get real testing for scripts.Glad you like it :)Rudy

RE: SQL Server Documentor

Lee Linares — Mon, 19 Nov 2012 11:20:00 GMT

Rudy,Thanks for sharing this excellent script. I ran into one small issue and got this error:Msg 15281, Level 16, State 1, Procedure sysmail_help_status_sp, Line 0SQL Server blocked access to procedure 'dbo.sysmail_help_status_sp' of component 'Database Mail XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Database Mail XPs' by using sp_configure. For more information about enabling 'Database Mail XPs', see "Surface Area Configuration" in SQL Server Books Online.This was because Database Mail was not enabled. I corrected this by adding a simple IF statement around the INSERT statement. So it went from this:CREATE TABLE #Database_Mail_Details(Status NVARCHAR(7))INSERT INTO #Database_Mail_Details (Status)Exec msdb.dbo.sysmail_help_status_spTo this:CREATE TABLE #Database_Mail_Details(Status NVARCHAR(7))IF EXISTS(SELECT * FROM master.sys.configurations WHERE configuration_id = 16386 AND value_in_use =1) BEGIN INSERT INTO #Database_Mail_Details (Status) Exec msdb.dbo.sysmail_help_status_sp ENDYou also had the the outputs for Section 7 (Last Backup Dates) and section 8 (List of SQL Jobs) reversed.Thanks again for taking the time to share this script.Lee

SQL Server Documentor

Rudy Panigas — Tue, 16 Oct 2012 15:38:09 GMT

Comments posted to this topic are about the item [B]SQL Server Documentor[/B]