Re: table ownership change
From: Carlos Eduardo Rojas (carloser_at_mindspring.com)
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" <email@example.com> wrote in message news:firstname.lastname@example.org... > 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