Create a cursor containing all the objects (tables, views, ... etc.).
For each object execute sp_changeobjectowner.
"LP" <londonporayahoo.co.uk> wrote in message
news:OGdcqNvRDHA.212TK2MSFTNGP10.phx.gbl...etc)> I need to change object ownership for all objects (sp's, tables, views,script> from SGLuser to dbo for a sql 7 db. Can anyone give me an idea of the> involved (either using sp_changeobjectowner or other) ? Any help