how can I do it

[habesha]

I want to rename all stored procedures in my database

eg if the procedure's name is proc I want to rename it like dbo.proc
I want to do it to all my procedures in my database.
How can I do this with a single query

Thanks

 

[SQLDenis]

dbo. is the object owner and NOT part of the proc name

lookup sp_changeobjectowner in BOL

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[SQLBill]

Then lookup FAQ183-4107. That will show you how to run it against all your tables/databases.

-SQLBill

Posting advice: FAQ481-4875