Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL   (RSS)

HOW TO TERMINATE SQL JOBS AFTER CUT-OFF PERIOD

NOTE: This method should not be attempted on the following jobs: Ø   Reindex Ø   Update Statistics Ø   Replication Ø   Backup How many times have we encountered a SQL job which runs for a long time (more than expected) only to error Read More...
Posted Wednesday, November 04, 2009 5:42 AM by AmruthaVarshiniJ | 0 Comments
Filed under: , , ,

HOW TO DETECT SQL SERVER INSTANCES / FEATURES INSTALLED ON A MACHINE

Have you ever wondered if there is a programmatic way to detect all the SQL server instances and services installed on a machine. Well, worry no more as the code below will do exactly that. There are 2 ways to go about this, Method 1 – For the Programmer Read More...
Posted Saturday, March 07, 2009 6:11 AM by Pariks | 2 Comments
 
Page view tracker