Re: procedure with temp tables

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 21:02:57 +0100

What do you mean by 'failing'? Are you getting any errors? Do you have SET
NOCOUNT ON at the begining of your stored procedure? 

-- 
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Subbaiahd" <subbaiahd@hotmail.com> wrote in message
news:ONO20BeZEHA.712@TK2MSFTNGP11.phx.gbl...
> I wrote a stored procedure which uses temp tables in its logic, tested it
in
> query analyser it is executed without errors, when i try to execute it in
> DTS activex script, it is failing. If i remove temp tables usage inside
> procedure i am able to execute in the same activex script, can someone get
> me more insight of it.  is it really a problem ?, if it is how to avoid
it.
>
> Thanks,
> Subbu.
>
>

Relevant Pages

  • Re: "Must declare the scalar variable @Nickname"...
    ... what's failing is the stored procedure: ... count or debug the sproc. ... Regards. ...
    (microsoft.public.dotnet.framework.aspnet)
  • procedure with temp tables
    ... I wrote a stored procedure which uses temp tables in its logic, ... DTS activex script, it is failing. ... If i remove temp tables usage inside ... procedure i am able to execute in the same activex script, ...
    (microsoft.public.sqlserver.dts)
  • Re: Debugging stored procedure in visual studio?
    ... so I can get an idea, where it is failing... ... for the calling code segment, ... > I have a stored procedure wich is inoked through my asp.net code. ... > from visual studio.net or maybe from sql server 200 itself? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Error trying to Insert into Table -
    ... I have a stored procedure that is failing to insert into a table. ... manually run the INSERT statement in SQL QA, ... first part of the error message. ...
    (microsoft.public.sqlserver.replication)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)