Lessons Learned in Execution

Note: This article is updated at Project Execution Lessons Learned. I’ve been thinking about execution and the lessons learned.   I’ve summarized some insights and reminders. I’ve been lucky enough to grow up with patterns & practices over the last 10 years, so I’ve been able to see what works, what doesn’t, and the difference that…


Restore of Replicated Database fails with “Cannot drop the table <tablename> because it is being used for replication.”

Restore of Replicated Database fails with “Cannot drop the table <table name> because it is being used for replication.” Sateesh Yele Microsoft SQL Server Support Issue: Restore of a replicated database fails with the following message. Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line 32 Cannot drop the table ‘dbo.MSpeer_lsns’ because it is being…


Distribution Agent fails with “Could not remove directory” error

Distribution Agent fails with “Could not remove directory” error Sateesh Yele Microsoft SQL Server Support Symptom: The Distribution Clean up job fails with the following error. Executed as user: DomainnameUsername. Could not remove directory ‘C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLReplDataunc’. Check the security context of xp_cmdshell and close other processes that may be accessing the directory. [SQLSTATE…