Ask the Expert

Running a stored procedure in context with the master database

I have a stored procedure "Test" running in context with say, the db1 database. I want the stored procedure to run in context with the master database - not db1. How is this done?

    Requires Free Membership to View

To access objects in the master database, you can specify the three part name for the objects eg: master.dbo.someobject from a proc in any database.

This was first published in June 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.