Re: table ownership change
From: Carlos Eduardo Rojas (carloser_at_mindspring.com)
Date: 07/11/03
- Next message: Phil: "Re: Object Created under DBO to different owner name"
- Previous message: gax700: "Re: table ownership change"
- In reply to: stevo: "table ownership change"
- Next in thread: Matteo Mago Merlano: "table ownership change"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: Phil: "Re: Object Created under DBO to different owner name"
- Previous message: gax700: "Re: table ownership change"
- In reply to: stevo: "table ownership change"
- Next in thread: Matteo Mago Merlano: "table ownership change"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
