Please refer to
"Database Context and referencing user tables"
I have a similar situation to the one in the question above.
I want to be able to share stored procedures between similarly structured databases, and the solution presented suits me fine, but....
1) I have created a few sample test stored procedures in Master, and now I want to either delete them, change them or rename them, but since they are marked system, I am not allowed to. How do I do that? (For obvious reasons there is no sp_unmarkSystem!)
2) I am unconfortable with resorting to the Master table to solve this. Is there another solution to this situation that does not use the Master Database?