SELECT INTO tempdb..

From: "Pat" <GTQWVOPHMEAQ@xxxxxxxxxxxxx>
Date: 9 Dec 2005 07:48:41 -0800

I have tested a stored procedure that SELECT INTO tempdb..myAppTable in
development as an user who has dbo rights. Hence, the table can be
referenced as tempdb.dbo..myAppTable.

However, when the same stored procedure is run in production as a user
who has only guest role, the same table can only be referenced as
tempdb.guest.myAppTable.

Can the SELECT INTO be modified so the dbo has table ownership?

.

Follow-Ups:
- Re: SELECT INTO tempdb..
  - From: darkknight56

Prev by Date: Re: Help required with Timestamp field
Next by Date: bcp into syslogins
Previous by thread: Help required with Timestamp field
Next by thread: Re: SELECT INTO tempdb..
Index(es):
- Date
- Thread

Relevant Pages

Re: Changed all objects from dbo to non dbo, now cannot send parameters
... change the ownership so that everything is owned ... However, when i run the adp, it fails. ... Dim rst As New ADODB.Recordset ... ' Set CommandText equal to the stored procedure name. ...
(microsoft.public.access.adp.sqlserver)
Re: UPDATE problems with Parameters
... the parameters defined in your stored procedure. ... Peter ... Prev by Date: ...
(microsoft.public.dotnet.framework.adonet)
Re: DTS packages or stored procedures?
... a DTS script or a stored procedure ... with linked (SQL) servers? ... Prev by Date: ...
(microsoft.public.sqlserver.dts)
Re: Compile Error Argument not optional for Parameter.Append
... I am using Microsoft SQL Server ODBC Driver Version 03.85.1117. ... The stored procedure is used to replicate data over to another table. ... Prev by Date: ...
(microsoft.public.vb.general.discussion)
Re: Too many args when running a stored procedure
... than you will get an error message. ... Which has nothing to do with the stored procedure by the way. ... Cor ... Prev by Date: ...
(microsoft.public.dotnet.languages.vb)