Re: table ownership change

From: Carlos Eduardo Rojas (carloser_at_mindspring.com)
Date: 07/11/03


Date: Fri, 11 Jul 2003 15:26:01 -0400


use the sp_changeobjectowner system stored procedure.

-- 
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"stevo" <steve_million@hotmail.com> wrote in message
news:08b901c347df$70419090$a001280a@phx.gbl...
> Is there a sp or command to change ownership on a table?
> I restored production db to dev db and now tables that
> aren't owned by dbo are not responding to certain log ins
> on my dev.  Seems like it happened after going to sp3 on
> the dev server.  I've tried altering security settings but
> it doesn't let me get anywhere.  Thanks