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.
Advertisements
  1. 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! 😀

  2. Bad link (sp_Template.sql) – did not check the others

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: