Category:

Change Table Owner Of All Tables

DECLARE tabcurs CURSOR
FOR
    SELECT 'OLDUSER.' + [name
      FROM sysobjects
     WHERE xtype = 'u'

OPEN tabcurs
DECLARE @tname NVARCHAR(517)
FETCH NEXT FROM tabcurs INTO @tname

WHILE @@fetch_status = 0
BEGIN

    EXEC sp_changeobjectowner @tname, 'NEWUSER'

    FETCH NEXT FROM tabcurs INTO @tname
END
CLOSE tabcurs
DEALLOCATE tabcurs

SQL Server

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count: