Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Archives: January 2010

Stored Procedure to Get SQL Job Execution Status


Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a while searching on Google I did not turn up anything I liked so I turned to Profiler and started looking at what calls SQL Management Studio uses. After a… Read more

0 comments, 1,525 reads

Posted in Adventures in SQL on 31 January 2010

Using sp_ExecuteSql to Run Dynamic SQL


Lately it seems like I am being bombarded by Dynamic SQL and people who insist it is the only way to accomplish something. Dynamic SQL is almost never the best way to accomplish a given task, but sometimes (and I do mean just sometimes) it is. In the post… Read more

0 comments, 318 reads

Posted in Adventures in SQL on 21 January 2010