Thanks for the store procedures (much nicer way of doing it:-)
Ste
Steven Moore
Internet Development Engineer
Research Machines
+44 1235 823522
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Craig Gittens
> Sent: 22 June 2001 12:58
> To: [EMAIL PROTECTED]
> Subject: RE: [IMail Forum] OT: SQL
>
>
> Thanks for the response Steven. I found a way yesterday
> evening before I got
> your email. My method is:
>
> Query:
> sp_changeobjectowner 'username.socamail_com','dbo'
>
> It's a built in stored procedure. There is also one for the
> entire database:
> sp_changedbowner
>
> Thanks for the help. My theory was correct, once I changed
> the owner of the
> table to 'dbo' Imail just loved it. Note, my wording was
> incorrect in my
> previous email, instead of 'database', it should be 'table'.
>
> Craig.
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of STEVEN MOORE
> (IFL)
> Sent: Friday, June 22, 2001 4:01 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: [IMail Forum] OT: SQL
>
>
> 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/
>
>
> 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/
