Author Archives: admin

Altering SQL Server stored procedure while it’s running

“Msg 2801, Level 16, State 1, Procedure dbo.sp_alterSP_break_execution, Line 16 [Batch Start Line 0]The definition of object ‘sp_alterSP_break_execution’ has changed since it was compiled.” I get this is error message when alter stored procedures on servers that are frequently called. … Continue reading

Posted in Uncategorized | Leave a comment