I'll try that article. Thanks.

I forgot to mention that UDFs work only on SQL Server 2000.

I would use UDF. UDFs are very similar to views in the sense that you can use a UDF as part of a SELECT statement and yet more powerful in...

Thanks guys for all the help. I am going to try some of the ideas presented.

tymberwyld, if Ident_Current('MyTable') is used, how would you know if the returned IDENTITY actually corresponds to your insert not any other user's insert?

Why @@IDENTITY is not returning what it's suppose...

As a reply to brendthess, if I don't use disconnected recordsets it works!! Both functions are using the same connection.

tymberwyld, I don't have any updates. What I am doing is...

Thanks Greg. I'll give that a try. I think the second solution may be the one.