Owner permissions to create Stored Proc | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Owner permissions to create Stored Proc

Hi Guys, Any one can help me … When I created a Stored Procedure in sql2000. It created successfully.
But the owner of the Stored Proc is on my name instead of DBO. What are the owner permissions I need to provide to create Owner of the object (TableSpViewTriggerRule) as DBO. Note: My role does not have DB_OWNER Permissions. With Regards
Sreenivas Reddy B
Kindly don’t duplicate posts.
Luis Martin
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.