Just login as "sa" this will give you object ownership.
-----Original Message----- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: 01 March 2006 13:07 To: CF-Talk Subject: Re: Setting db ownership to dbo There's a SP if you have access to it . . .. i'm not at my normal system now so I'm not sure of the syntax, and it's a month or two since i used it but i think it goes like this: EXEC sp_changeobjectowner 'tablename', ;dbo' Check in books online if that syntax doesnt work. You can use the SQL area of EntMgr or you can even use query manager. Of if you dont have access with those, you can use CFQUERY in a coldfusion file and run it. Hope this helps you. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/1/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > How do you set owner to dbo in enterprise manager for mssql? > > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233729 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
