Re: table ownership change

From: Carlos Eduardo Rojas (
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" <> wrote in message
> 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