<div>
Have you tried running this query as a stored procedure? &nbsp;I seem to remember running into this a while back and setting up an SP fixed it.
</div>


Have you tried running this query as a stored procedure?  I seem to remember running into this a while back and setting up an SP fixed it.

<div>
I do not want to do this as a stored procedure. &nbsp;I want to do this entirely with the ADO execute. &nbsp;It needs to be very generic.
</div>


I do not want to do this as a stored procedure.  I want to do this entirely with the ADO execute.  It needs to be very generic.

<div>
Also, although I know you say you don't want a proc, but a proc is the BEST thing for DB processing.
</div>


Also, although I know you say you don't want a proc, but a proc is the BEST thing for DB processing.

<div>
That's it -- SET NOCOUNT ON...I knew there was something I was missing. &nbsp;Brandon's right on the money.
</div>


That's it -- SET NOCOUNT ON...I knew there was something I was missing.  Brandon's right on the money.

<div>
Perfect. &nbsp;You got it. &nbsp;Thanks!
</div>


<div>
<div class="content wysiwyg-content">
In ASp i am doing this:<br />
<br />
set objrs=objconn.execute(&quot;ins<wbr />ert into cart (title) values ('something');select SCOPE_IDENTITY() as id;&quot;)<br />
<br />
When I check objrs(&quot;ID&quot;) it returns blank. &nbsp;Nothing. &nbsp;This works fine access but not in SQL 2000. &nbsp;I find that it seems to have something to do with it being in the second line of the SQL. &nbsp;if I replace the scope_identity() with max(cartid) i get the same thing. &nbsp;So the second line is not returning a value.<br />
<br />
Running this in the query analyzer DOES return the value as expected.<br />
<br />
Any ideas?
</div>
</div>


In ASp i am doing this:

set objrs=objconn.execute("insert into cart (title) values ('something');select SCOPE_IDENTITY() as id;")

When I check objrs("ID") it returns blank.  Nothing.  This works fine access but not in SQL 2000.  I find that it seems to have something to do with it being in the second line of the SQL.  if I replace the scope_identity() with max(cartid) i get the same thing.  So the second line is not returning a value.

Running this in the query analyzer DOES return the value as expected.

Any ideas?

cannot get a value from scope_identity after insert

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.