Quick Contact

ChangeDBownerOnTables

Simple SQL for change DB owner.

select 
      'ALTER SCHEMA dbo TRANSFER ' + sys.schemas.name + '.' + sys.tables.name
from 
      sys.tables inner join sys.schemas on sys.tables.schema_id=sys.schemas.schema_id

run this Sp

Copy paste and run output.

Additional Articles
X

Partners

© 2013 XGlobe Online Ltd.