Made By SQL
Knowledge is a treasure, but practice is the key to it.
Saturday, August 28, 2010
Creating SP in Master database
So you want to create a stored procedure
in the master database in order to be able
to access it from any database in the server
without specifing the fully qualified name
and take an advantage of dynamic contex,
meaning the procedure will be executed in
the context of the calling database.
Ok, first of all, give prefix "sp_" and another thing you should
You have to mark the SP as
in order to make the
dynamic contex thing working.
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)