How to update all objects in a table to DBO
May 15, 2018
Neat, elegant little script to update all objects in a table (back) to dbo:
EXEC sp_msforeachtable "sp_changeobjectowner '?', 'dbo'"
SHARE THIS POST:
Neat, elegant little script to update all objects in a table (back) to dbo:
EXEC sp_msforeachtable "sp_changeobjectowner '?', 'dbo'"