Y
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.