How can I update the data in a column in a system catalog table. (ie. I want to globally change the owner of some stored procedures to dbo from the original user who created them. The table I want to change is sysobjects. The column is UID. I am trying to change UID 6 to UID 1.)
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
System Tables
- Thread starter rdemotsis
- Start date
I would recommend that you use sp_changeobjectowner rather than modifying the system tables directly. Robert Bradley
Do you have too much money? Visit
Do you have too much money? Visit
- Status
Similar threads
