I gather you have SA login ability? If so, create and run this sproc



http://support.microsoft.com/default.aspx?kbid=275312



   _____  

From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: 23 August 2004 14:50
To: SQL
Subject: How to change ownership? (SQL 2K)

We have a database that has two tables with improper ownership. I want to
change the ownership back to "dbo". Where do I need to look to do this? I
have a DTS package that won't run because of the ownership of these two
tables....argh...

   _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to