We are using SCOPE_IDENTITY and we are still getting these unexpected results. The scenario is as follows: Insert into Table A (which has an identity column) which fires a trigger adding a row to Table B which has an identity column. On subsequent inserts or updates the identity from Table B is used instead of the identity from Table A. This is happening in an application written in VB 6 using SQL Server 2000. Any suggestions?
re: Recommending @@Identity? I Woudn't.
Categories:
No TrackBacks
TrackBack URL: http://betav.com/blogadmin/mt-tb.cgi/1943
Categories
- Administration Notes (3)
- Announcements (14)
- Books, Articles, Papers (11)
- Consumer Issues (16)
- Development (79)
- Data Architectures (50)
- Entity Framework
- SQL Server (71)
- SharePoint
- Reporting Services Integration
- Tools
- Data Architectures (50)
- Events and Conferences (21)
- Future Conferences (11)
- In the past (6)
- Progressive
- Webinars (3)
- Hardware (8)
- Old Blog (252)
- Politics (7)
- Software (3)
- Veteran's Affairs (1)
- Voting Machines
- Windows/XP/Vista/Windows 7 (10)
Monthly Archives
- August 2010 (4)
- July 2010 (4)
- June 2010 (2)
- May 2010 (3)
- April 2010 (5)
- March 2010 (1)
- February 2010 (3)
- January 2010 (5)
- October 2009 (3)
- September 2009 (4)
- August 2009 (2)
- June 2009 (6)
- May 2009 (4)
- April 2009 (3)
- March 2009 (10)
- February 2009 (15)
- January 2009 (6)
- November 2008 (8)
- October 2008 (15)
- September 2008 (1)
- August 2008 (9)
- April 2008 (1)
- December 2007 (1)
- August 2007 (3)
- July 2007 (1)
- June 2007 (1)
- May 2007 (1)
- January 2007 (2)
- November 2006 (5)
- September 2006 (4)
- August 2006 (9)
- July 2006 (1)
- June 2006 (8)
- May 2006 (17)
- April 2006 (9)
- March 2006 (12)
- February 2006 (7)
- January 2006 (10)
- December 2005 (11)
- November 2005 (15)
- October 2005 (13)
- September 2005 (26)
- August 2005 (23)
- July 2005 (28)
- June 2005 (15)
- May 2005 (21)
- April 2005 (21)
- March 2005 (26)
- February 2005 (37)
- December 2004 (2)
- November 2004 (2)
Pages
Search
About this Entry
This page contains a single entry by William Vaughn published on May 11, 2006 9:19 AM.
re: WARNING: Don't Try to Fix Your Daughter's Laptop after 8PM was the previous entry in this blog.
re: Recommending @@Identity? I Woudn't. is the next entry in this blog.
Find recent content on the main index or look in the archives to find all content.
Leave a comment