How to change owner of a stored procedure

[jfield817]

Using SQL Server 7.0 .....
The owner of a stored procedure was dbo, however I entered the query manager under a different login id and pw and changed a stored procedure and saved it .

Now the table is owned by the name I logged in with ....

How do I restore the dbo ownership of that stored procedure ?

Thanks,
John

 

[foxdev]

You can use SP_CHANGEOBJECTOWNER.

Robert Bradley

http://www.foxdev.com/

 

[jfield817]

Robert,

So then I assume that the syntax would be:
EXEC sp_changeobjectowner 'procname', 'dbo'

Thanks,
John

 

[foxdev]

Yes. To change it to an NT user, use syntax similar to this:

[tt]sp_changeobjectowner 'procname', 'mydom\myuser'[/tt]


Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[jfield817]

It worked ...thanks

John Field