Hacker News new | ask | show | jobs
by chris_wot 4067 days ago
CREATE PROCEDURE puts a schema lock on the procedure. Didn't realise it doesn't release it! SQL Server only allows one Sch-M lock on an object at a time.