change owner of objects
-
Hi dears, How can I change owner of all tables and stored procedures in my database? I know with executing stored procedure sp_changeobjectowner I can do it , but I don`t want to execute it for each table and sp, Thx for your help
modified on Wednesday, January 02, 2008 5:20:30 AM
-
Hi dears, How can I change owner of all tables and stored procedures in my database? I know with executing stored procedure sp_changeobjectowner I can do it , but I don`t want to execute it for each table and sp, Thx for your help
modified on Wednesday, January 02, 2008 5:20:30 AM
Do you want to change the owner of the database? You can change using sp_changedbowner
------------------------------------------------------------ "The only true wisdom is in knowing you know nothing." --Socrates
-
Hi dears, How can I change owner of all tables and stored procedures in my database? I know with executing stored procedure sp_changeobjectowner I can do it , but I don`t want to execute it for each table and sp, Thx for your help
modified on Wednesday, January 02, 2008 5:20:30 AM
Does your database have any data in it? If not, you could always just generate the create script for your database and then change the owners using a global search and replace. There are other ways, but this is the easiest.
Deja View - the feeling that you've seen this post before.