This stored procedure takes in a database name and returns all spids for that databases.
2004-08-24 (first published: 2004-05-04)
Originally authored by M.Pearson, this script gets all the scheduled jobs and lists out the different run statistics. I added the ability to derive Average run times, based on Start date and End date
2004-08-23 (first published: 2004-04-23)
2004-08-20 (first published: 2004-04-20)
This is an extension of two previous scripts, this one will produce a list of ojects that contain the first parameter and not the second. The function works as a table so if the user wants to list only functions, query as: select * from fn_sys_searchobject('text1','text2') where object_type = 'function'
2004-08-19 (first published: 2004-04-14)
2004-08-18 (first published: 2004-04-13)