T-SQL

Apr
23

Dynamically getting the execution status of a SQL Server Agent Job

Ranjith on April 23rd, 2010

This problem seems trivial but there is no straight forward way to get this information. If you have tried the INSERT into EXEC command to insert the results of the sp_help_job procedure into a temporary table like below then you are familiar with the below error. insert into #jobstatus execute msdb..sp_help_job Msg 8164, Level 16, [...]

Continue reading about Dynamically getting the execution status of a SQL Server Agent Job

T-SQL 4 Comments »
Jan
31

Script to drop all objects of a Schema in SQL Server

Ranjith on January 31st, 2010

I have spent almost 3 hours to complete this script and test it for couple of sample scenarios during this weekend (31/01/10).  It drops all the objects of the schema and then drops the schema itself. And automatically takes care of all the object dependencies with in the schema by dropping all of them in [...]

Continue reading about Script to drop all objects of a Schema in SQL Server

T-SQL 26 Comments »