<div>
not really likely to work as it's a multi-user system<br />

</div>


not really likely to work as it's a multi-user system


<div>
Why dont you &nbsp;create a stored procedure on the remote server which inserts and returns the identity value thru an output variable. then you can create a synonym to that sp and call it from ur local sp 
</div>


Why dont you  create a stored procedure on the remote server which inserts and returns the identity value thru an output variable. then you can create a synonym to that sp and call it from ur local sp

<div>
I can't create an SP on the remote server so that's out of the question.<br />

</div>


I can't create an SP on the remote server so that's out of the question.


<div>
<div class="content wysiwyg-content">
My stored procedure does an insert command to a table with identity(1,1) on a remote server using a synonym.<br />
<br />
How can I get the ID of the record that was just inserted? &nbsp;Scope_Identity() doesn't work, is there any alterative? I can't create an SP on the remote server so that's out of the question.<br />
<br />
Is there any other way?
</div>
</div>


My stored procedure does an insert command to a table with identity(1,1) on a remote server using a synonym.

How can I get the ID of the record that was just inserted?  Scope_Identity() doesn't work, is there any alterative? I can't create an SP on the remote server so that's out of the question.

Is there any other way?

Scope Identity on remote server

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.