Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: December 2010

Strange issue while using IDENTITY values in INSTEAD OF triggers

Found an interesting issue last week....it goes like this: If you are using INSTEAD OF triggers on views (in SQL 2005) and you need to retrieve IDENTITY values you have to be very careful how you do it. It turns out that a simple SELECT from the inserted table can…

Read more

0 comments, 300 reads

Posted in Sam Bendayan's 2 Cents on 23 December 2010