THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Automation » Scripting   (RSS)
  • Scripting for the out-of-band attention

    I have written a lot of throw-away scripts, some of which were written to control the execution of a large number of SQL scripts. The logic of these control scripts is often simple, but their execution can last for a long time (e.g. hours). When writing this type of control scripts, people would generally give some thoughts to improve robustness ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 20, 2010
  • Logging for post-processing

    As a practicing database professional, I'm sure you have done a lot of logging, I mean, output and/or error logging from your scripts, your scheduled jobs, and any other programs you might have written. The primary purpose of logging, of course, is to facilitate troubleshooting in case something goes wrong.  Often, people don't give much ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 17, 2010
  • Get an overview report on your log shipping setups

    [Updated Dec 23 to include a T-SQL script at the bottom of the post].   You may have an environment where log shipping is set up on various databases between various servers. Would it be handy to have an overview report highlighting which database is being log shipped where? Even if you have some kind of record to keep track of the ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on December 21, 2009
  • Find the complete call tree for a stored procedure

    Would it be nice to print out the complete call tree of a stored procedure? By complete call tree, I mean the following:   ·              At the very top level, the call tree should identify all the procedures that are called ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 22, 2009
  • Executing a large number of SQL scripts

    Say, you are given a large number of scripts underneath the following directory tree:   N:\Apps\Release\PRS\PR12345\CMP1\procs                                ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on December 4, 2008
Privacy Statement