Database Knowledge Base / MS SQL Server /
Email to friend
* Your name:
* Your email:
* Friend's email:
Comment:


how we can change ownership in SQL Server?

DECLARE @old sysname,
@new sysname,
@sql varchar(1000)

SELECT
  @old = 'webwin_whomakeswhat'
  , @new = 'dbo'
  , @sql = '
  IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES
  WHERE
      QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''
      AND TABLE_SCHEMA = ''' + @old + '''
  )
  EXECUTE sp_changeobjectowner ''?'', ''' + @new + ''''

EXECUTE sp_MSforeachtable @sql




RSS