Introduction to Stored Procedures

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Sean Burke » Introduction to Stored Procedures

Introduction to Stored Procedures

Rate Topic

Display Mode

Topic Options

Author

Message

Sean Burke

Posted Thursday, July 05, 2001 12:00 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, August 29, 2002 12:00 AM
Points: 72, Visits: 1

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sburke/introductiontostoredprocedures.asp

Post #513

nsearle

Posted Friday, May 24, 2002 7:06 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, August 02, 2002 12:00 AM
Points: 6, Visits: 1

Great article, but I'm having problems with who the owner should be in the CREATE PROCEDURE line.
When I try to enter my own username as the owner, it shows an error message, and won't let me save the procedure. I have also tried 'dbo_user' with the same result.
I've read elsewhere that the owner of the stored procedure should be the same as the owner of the objects it uses in order to avoid 'broken ownership chains'- whatever that is!
Who should the user be?

Post #19793

Andy Warren

Posted Friday, May 24, 2002 7:16 AM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Best practice is to have all objects owned by dbo. You can either create them and later change the owner, or you have to be the dbo (db owner) of the database. You can accomplish that either by connecting with any login that has sysadmin rights, or by setting up an alias for your login to dbo.

Andy

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #19794

nsearle

Posted Friday, May 24, 2002 7:17 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, August 02, 2002 12:00 AM
Points: 6, Visits: 1

Okay- that works. Thanks a lot.

Post #19795

philcart

Posted Sunday, September 29, 2002 9:58 PM

SSCrazy

Group: General Forum Members
Last Login: Friday, May 17, 2013 5:53 AM
Points: 2,692, Visits: 1,074

Good introductory article. Will you be doing a follow-up article? I'd like to see one on using the T-SQL templates which aid in quickly creating standardised SP's.

Thanks
Phill Carter

Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface

Australian SQL Server User Groups - My profile
Phills Philosophies
Murrumbeena Cricket Club

Post #19796

« Prev Topic | Next Topic »

Permissions