Re: An INSERT EXEC statement cannot be nested error.

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Mon, 28 Nov 2005 08:28:14 +0000 (UTC)

Scarab (pest9998@xxxxxxxxxxx) writes:
> When I use following sql, an error occurs:
> insert into #tmprep
> EXECUTE proc_stat @start,@end
>
> There is a "select * from #tmp " in stored procedure proc_stat, and the
> error message is :
>
> Server: Msg 8164, Level 16, State 1, Procedure proc_stat, Line 42
> An INSERT EXEC statement cannot be nested.
>
> What's the metter? Any help is greatly appreciated. Thanks

Yes, that's a restriction with INSERT-EXEC. See this article for
alternative solutions: http://www.sommarskog.se/share_data.html.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

References:
- An INSERT EXEC statement cannot be nested error.
  - From: Scarab

Prev by Date: About: An INSERT EXEC statement cannot be nested.
Next by Date: Re: CASE problem
Previous by thread: Re: An INSERT EXEC statement cannot be nested error.
Next by thread: CASE problem
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL Adaptor - Timeout
... Anyway there is not many methods to throttling: ... SQL send port trying to repeat the SP several times then suspend the ... Server stored procedures using SQL Server Adaptor. ... The adapter "SQL" raised an error message. ...
(microsoft.public.biztalk.general)
Re: update query ODBC--call failed
... Google results from searching for your error message, ... on the local server SQL database. ... reporting the error rather than the "ODbc Driver For SQL Server" ...
(microsoft.public.access.queries)
Re: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2
... The file that is attached to the "Open a Company" command is a text document that appears to just contain the connection string for the selected company. ... Server Express Edition locally, but cannot connect remotely, and if the SQL Server Express Edition is listening on Named Pipes, then I suspect a firewall issue on the computer that is running SQL Server Express Edition. ... Since the problem appears to involve some sort of interaction between Microsoft Office Accounting Professionaland SQL Express 2008 hopefully someone in this forum will understand the error message I'm receiving and can suggest some possible solutions for me to try. ...
(microsoft.public.sqlserver.connect)
RE: SQL Server 2000 desktop MSDE + Internet Explorer 7 = Cant con
... cannot open SQL Enterprise Manager. ... From the error message, it seems to be related to SSL and certifcate. ... Edit the registry on the SQL Server machine and make the following ...
(microsoft.public.sqlserver.connect)
cannot convert between unicode and non-unicode string data types
... Cindy, I have the same problem, there is a solution, In the OLE DB Destination component, in the Mappings option in the input column you must choose the Data Conversion., and that's it. ... I am converting a simple (at least in the SQL Server 2000 DTS days) to this ... error message stays the same ... numerous times I have inserted the transformation task between the oracle ...
(microsoft.public.sqlserver.dts)