sql server mseq: Changing 100 table object owner names at once -- sql server mseq

Changing 100 table object owner names at once

Smith
6/10/2004 3:06:19 PM

sql server mseq:

Is there any way I can change the object owner for over
100 tables in a single data base at once in SQL 7 without

RE: Changing 100 table object owner names at once

Nigel Rivett
6/26/2004 3:42:01 PM

Well you can do an update on sysobjects but if you look at the sp it does a lot of checking and clearing up.

Better to code a loop to execute it on all the tables necessary.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server mseq group.