Post reply

Changing DB Object Ownerships

  • September 16, 2005 at 8:49 am

    #89778

    Is there any easy way to change all of a database's existing table's ownership to  'dbo' in a script?  Does anybody have one already?

     

    Thanks,

     

    Daniel

  • September 16, 2005 at 9:20 am

    #590646

    sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply