>>>I don't get any error testing this SP in SQL Server:
>>>
>>>create PROCEDURE [dbo].[Get_Identity_value]
>>> @in int,
>>> @out int OUTPUT
>>>AS
>>>BEGIN
>>> SET NOCOUNT ON;
>>>
>>> set @out=@in
>>>
>>>END
>>>go
>>>declare @out int
>>>execute dbo.Get_Identity_value @in = 2, @out =@out output
>>>select @out
>>
>>I can see that your SP is the same as mine; so this eliminates problem with stored procedure. But the way you call the stored procedure is different. First you declare the variable "out"; I didn't. But you didn't declare "in" and I did.
>
>I could have declared @in also - I just used inline declaration.
I know. I think the issue has something to do with the aliased column name that I use in my code. Could it be that SQL Server sees it as a constant?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham