Re: How to change the owner of a table in SQL 65?

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 09/25/02


From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Tue, 24 Sep 2002 20:10:29 -0600


There is no supported way to do this in 6.5. You can find
information on unsupported methods at:
http://www.mssqlserver.com/faq/admin-changeowner.asp

-Sue

On Tue, 24 Sep 2002 15:37:46 +0200, Peter van der Veen
<pvdveen@nospammingvanbrug.nl> wrote:

>Hi
>
>How to change the owner of a table in SQL 65?
>Any idea how to do that?
>In SQL7/2000 there is a stored procedure to do this, but in SQl 65????
>
>
>
>Peter



Relevant Pages

  • Re: Missing table
    ... execute the commands within Query Analyzer. ... The first piece of sql displays the table owner, type, and the name of the table. ...
    (microsoft.public.sqlserver.server)
  • RE: Is the Folowing Applicationb Possible
    ... Therfore are you saying it is possible to create a useable app ... that uses SQL properly - but based around Sharepoint 'front end' AND is easy ... Then have a drop down list so that a users could easliy pick the owner. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: DAP & SQL 2000
    ... I imported everything I had in Access to SQL, ... everything I imported has the owner "quote" ... Even tho I imported 3 tables I only use 1 (which does have a primary key) ... > on the Data Outline view and, in the case of the source, has the owner be ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Permissions and ODBC
    ... objects have the same owner. ... case of dbo-owned objects in different databases, ... See the SQL 2003 SP3 Books Online for more ... > The Ms Access program executes a stored procedure that resides in SQL ...
    (microsoft.public.sqlserver.server)
  • RE: Job failed Error 7410
    ... Server Agent runs SETUSER to switch to the context of the owner of the Job. ... Since SETUSER cannot impersonate an NT user outside the context of SQL ...
    (microsoft.public.sqlserver.security)