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)...

Interlude: SSMS tips

Introduction

I know I said I was going to add more information about the CDC system in this post, but I...

Intel Sandy Bridge Processor Machines Coming Soon!

If you are in the market to buy or build a new laptop or desktop computer, you might want to...

SQL Server 2005 SP3 Cumulative Update 13 Released

Microsoft has released SQL Server 2005 SP3 Cumulative Update 13, which is Build 4315. It was actually released on Monday,...

SQL Server Scripts Manager From Redgate Software

Redgate Software has released a useful free tool called SQL Server Scripts Manager. I was happy to be included as...

Book Plug: Say Goodbye

I read a lot, and often marvel at the effort that goes into writing them, and I think I get...

SSIS to SQL Server Data Type Translations

I have found often when teaching SSIS to others that it can be extremely confusing when you first encounter SSIS...

Can You Dig It? – StmtCond Element

She can dig it!
D Sharon PruittA couple posts ago in the plan cache series I discussed the children for the...

The Real Purpose for Kindle

It finally dawned on me why people would bother getting a separate book-reading device like Kindle - and why it might...

SQL Server Storage Internals Part 4 - How to read a Heap page

I like to share 4 updates before moving on to this section:

1. I 've updated my profile to know more about...