Stored Procedure owner - how do you change it.

[Braveheart1326]

Hi there

I am relatively new to SQL Server so please bear with me as I ask what will probably be an easy question.

I have a developer who created a stored procedure and he is showing as the OWNER of it instead of DBO. I want to change the owner to DBO and thought I could use the sp_changeobjectowner stored procedure to do so but I dont appear to be able to get it to work.

Can anyone advise how I would attempt this.

Thanks
Ronnie

 

[JayKusch]

SO ... this command did not work????

sp_changeobjectowner @objname = 'StoredProcedureName', @newowner = 'DBO'

Of course you need to change 'StoredProcedureName' to the name of the SP you are trying to change.

You may not have the correct permissions on the account you are logged in with to accomplish this task.

Thanks

J. Kusch

 

[nigelrivett]

Drop the sp and recreate it using the correct owners profile.

But you should be able to use sp_changeobjectowner to do it.
Try using the owner.procname to specify the object to change.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Braveheart1326]

Hi there

Thanks for the guidance. I had tried to use the SP_changeobjectowner as per the books online example and it failed, however the example shown above when used was successful.

Many thanks
Ronnie

 

[JayKusch]

Morning Braveheart1326 ...

Which example/info above was the charm?

Thanks

J. Kusch

 

[Braveheart1326]

Hi again

The one thats listed as

sp_changeobjectowner @objname = 'StoredProcedureName', @newowner = 'DBO'

Thanks
Ronnie

 

[JayKusch]

Thanks ... Just checking ... have a good one!

Thanks

J. Kusch