Options

object owners

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 12, 2004 2:59PM in SQL Toolkit Previous Versions
Hi Mark,

The stored procedures will be created under the context of the logged-in user if the creation DDL (what you see when you double-click the object in Enterprise Manager) does not specify an owner. The only way around the problem is to ensure that your stored procedures are created with an owner name in the creation script.
This discussion has been closed.