Original message follows.
Received: from walnut.iea-software.com [207.53.165.8] by mail.soundcom.net with ESMTP
(SMTPD32-4.04) id A8166CD0110; Thu, 17 Sep 1998 13:59:02 PDT
Received: from walnut.iea-software.com (walnut.iea-software.com [207.53.165.8]) by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id za000843 for <ntisp@iea-software.com> Thu, 17 Sep 1998 13:36:12 +0100
Received: from [199.44.194.2] by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id yhiaaaaa for <ntisp@iea-software.com> Thu, 17 Sep 1998 13:36:07 +0100
Received: from alpha (alpha.talstar.com [199.44.194.2])
by alpha.talstar.com (Post.Office MTA v3.1.2 release (PO205-101c)
ID# 0-55710U1100L2S100V35) with ESMTP id AAA167
for <ntisp@iea-software.com> Thu, 17 Sep 1998 16:41:33 -0400
From: "Josh Hillman" <admin-maillist@talstar.com>
To: <ntisp@iea-software.com>
Subject: sa/dbo taking ownership of a SQL table
Date: Thu, 17 Sep 1998 16:41:32 -0400
X-MSMail-Priority: Normal
X-Priority: 3
X-Mailer: Microsoft Internet Mail 4.70.1155
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Message-ID: <19980917204133118.AAA167@alpha.talstar.com>
X-ListMember: ramses@soundcom.net [ntisp@iea-software.com]
Is it possible for sa (dbo) to take ownership of an existing SQL table
owned by "johndoe"? If this can't be done, is the only other option to
create a new table as sa/dbo and transfer the data from one table to the
other?
MSSQL Server 6.5 SP4 on Intel based NT4 SP3
Thanks for any info...
Josh Hillman
hillman@talstar.com