/* ########################## Macul.eti.br ########################## */ /* Criada xx/xx/200x Versão : 0.0 AUTOR : Marcelo Colla Desc: # */ /* ########################## Macul.eti.br ########################## */ DECLARE @AlterString NVARCHAR(500) Declare @VtableName varchar(50) DECLARE @Cursor CURSOR Set @Cursor = CURSOR FOR Select Rtrim(Name) as TName From SysObjects Where Xtype = 'U' Open @Cursor Fetch NExt From @Cursor Into @VtableName While @@Fetch_Status = 0 Begin Exec('EXEC sp_changeobjectowner ''' + @VtableName + ''', ''mcolla''') Fetch NExt From @Cursor Into @VtableName End
Por Marcelo Colla