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

Updated SQLRally Flyer

We’ve updated the original flyer to the new and improved model that has the prices. The image below is a...

Book Plug: Say Goodbye

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

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

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

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

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

Can You Dig It? – StmtUseDb Element

She can dig it!
D Sharon PruittThe last post in the plan cache series discussed the children for the Statements element. ...