Owner

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

Adam Angelini SSCrazy Eights Points: 8548 More actions · Answer 1

SSCrazy Eights

Points: 8548

April 10, 2007 at 9:04 am

sp_changeobjectowner

Nita Reddy SSCarpal Tunnel Points: 4177 More actions · Answer 2

SSCarpal Tunnel

Points: 4177

April 10, 2007 at 9:40 am

how should I do for 100 tables

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 3

Get a list of tables into Excel.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 4

Run this in QA, then run the results:

select 'exec sp_changeobjectowner ''' + name + ''',''newowner'''

from dbo.sysobjects

where xtype in ('U', 'P')

Greg