RE: Inserted Identity Values in SQL 2005

Hi David,
Just post additional information here. As a workaround, I recommend that
you use IDENT_CURRENT('tablename') to replace the @@IDENTITY. Per my test,
it is stable to use IDENT_CURRENT. I also tried use SCOPE_IDENTITY(),
however it seemed that it could not work in ADO.

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================



.

Relevant Pages

  • RE: accelerator keys dont work in a modal ATL dialog
    ... I am sorry for the late response due to a sick leave yesterday. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ... When responding to posts, ...
    (microsoft.public.vc.atl)
  • RE: Repost: Example of using MarkAsTask?
    ... Microsoft Online Community Support ... For MSDN subscribers whose posts are left unanswered, ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.interop)
  • RE: Exponent Format specifiers for %g
    ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ... When responding to posts, ...
    (microsoft.public.vc.language)
  • Re: Intermittent work in UI thread
    ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.vc.mfc)
  • RE: accelerator keys dont work in a modal ATL dialog
    ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ... When responding to posts, ...
    (microsoft.public.vc.atl)