THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Developer » TSQL   (RSS)
  • Stopping Execution of Future Batches

      There is a command that as far as I can tell has been in the product since SQL2008 but I was woefully unaware of. Actually I find many others are unaware as well and hence the blog post. The command is SET NOEXEC which has options for ON or OFF.  Normally this is OFF by default and the issue I was trying to solve was this: I have a ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 17, 2017
  • Cleaning up Un-Named Defaults

    I just had a situation in which we are automating the comparing of databases and I came across a bunch of Defaults that were never explicitly named. This causes them to get a new name each time you create them and makes it much more difficult to write future update scripts when you don’t know the actual name it will be. In any case I decided to ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 26, 2009
Privacy Statement