Code Repository

This page is a repository for the code found in some of my blog posts.

If you like my code, feel free to download it and use it.

Code	Post
sp_Template.sql	My stored procedure code template
dba_runCHECKDB.sql	Setting up an e-mail alert for DBCC CHECKDB errors
dba_ForEachDB.sql	A better sp_MSForEachDB
verify_script.sql	How to Eat a SQL Elephant in 10 Bites
CustomDateFormat.cs	SQL Server and Custom Date Formats
formatDate_Islands_iTVF.sql	SQL Server and Custom Date Formats
formatDate_Recursive_iTVF.sql	SQL Server and Custom Date Formats
formatDate_scalarUDF.sql	SQL Server and Custom Date Formats
parseDate_Islands_iTVF.sql	SQL Server and Custom Date Formats

Archived WordPress comments (4)

Historical comments from the original site; this archive is read-only.

David Warner March 27, 2014 at 11:27
Good Morning,
I have had an issue with the pre-2012 version of the DBCC CheckDB script ... in the Catch statement on line 279 I have had to insert the error handling that you provide as part of lines 439 to 446 ... my error was that TempDB wasn't sized correctly and the only error I received was "The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction. [SQLSTATE 42000] (Error 50000)" with the additional error handing it logged the reason for the job failure as lack of space in TempDB. Aside from that it is extremely useful piece of code! :-D
1. spaghettidba March 27, 2014 at 11:39
  Good to hear!
  I hope you solved your issues with the new version.
Dirk October 5, 2017 at 07:23
Bad link (sp_Template.sql) - did not check the others
1. spaghettidba October 6, 2017 at 15:03
  Thanks for the heads-up! It was Dropbox that decided to change permalinks. Got rid of them and use gists now. Thanks again!