I'm stupid. you are using MASTER and I made a best practice comment on the assumption you weren't using MASTER. I should stop answering the phone when I read these columns. :hehe:

Just an aside, I never name my stored procedures with sp_XXX as this is normally reserved to MASTER.

It also causes additional searches and added i/o

It will first search MASTER for the procedure, if not found it will then acquire a exclusive COMPILE lock to perform a second search of the other databases

Also if the procedure has the same name as an sp_XXX procedure in MASTER your stored procedure will never execute