Monthly Archives: October 2014

Replication-Distribution Agent is already running


Very rarely should you acquire the following error, which can be viewed when looking at the job activity monitor failure history: “Agent message code 21036. Another distribution agent for the subscription(s) is running or the server is working on a … Continue reading

Posted in Replication | Leave a comment

Replication : Can’t find stored procedure


Occasionally, an error will display such as one of the following: “Could not find stored procedure ‘sp_MSdel_ARTICLE_msrepl_ccsr’“ “Could not find stored procedure ‘sp_MSins_ARTICLE_msrepl_ccsl’“ “Could not find stored procedure ‘sp_MSupd_ARTICLE_msrepl_ccsl’“ It is unclear how the stored procedure gets dropped from the … Continue reading

Posted in Uncategorized | Leave a comment

Backup Duration FInd


The following query gives the recent backup duration by user, Database name, server name, Backup started , Backup Finished and Total Time. DECLARE @dbname sysname SET @dbname = NULL –set this to be whatever dbname you want SELECT bup.user_name AS … Continue reading

Posted in Uncategorized | Leave a comment