If you're brave you can switch on adhoc changes to system tables.
To do this:
>From Enterprise manager right click on the relevant SQL server select
Properties.
Select the "Server Settings" tab.
Select "Allow modifications to be made directly to the system catalogs".
to change the owner, goto the relevant database, open the sysobjects table
find the relevant entry for the table you want to change. Change the uid
field to 1 (this is the dbo).
Close the table.
refresh the interface and the table should now be owned by dbo.
Switch off adhoc changes
Obviously make sure your backup works properly before you do any of this.
Hope that helps
Steve
Steven Moore
Internet Development Engineer
Research Machines
+44 1235 823522
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Craig Gittens
> Sent: 21 June 2001 20:36
> To: IMail_Forum@list. ipswitch. com
> Subject: [IMail Forum] OT: SQL
>
>
> I know this is way off, if you can help I would appreciate
> it. Is there a
> way to change the ownership of a database in sql7 to 'dbo' rather than
> whatever it might be?
>
> I am having headaches moving an imail database from one machine to the
> other.
>
> I backup and restore the database, and point imail toward it.
> Imail ignores
> the database that is there and recreates another of the exact
> same name that
> belongs to dbo. So I am thinking, if I can get the database
> to belong to
> dbo, Imail might use it instead.
>
> Any ideas?
>
>
> Craig
>
>
> Please visit http://www.ipswitch.com/support/mailing-lists.html
> to be removed from this list.
>
> An Archive of this list is available at:
> http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
>
Visit our website at http://www.rm.com
Standard Disclaimer:This message is confidential. You should not copy it or
disclose its contents to anyone. You may use and apply the information only
for the intended purpose. Internet communications are not secure and
therefore RM does not accept legal responsibility for the contents of this
message. Any views or opinions presented are only those of the author and
not those of RM. If this email has come to you in error please delete it
and any attachments. Please note that RM may intercept incoming and
outgoing e-mail communications.
Please visit http://www.ipswitch.com/support/mailing-lists.html
to be removed from this list.
An Archive of this list is available at:
http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
