Systems Engineering and RDBMS

An important Fix: KB 967169

Posted by decipherinfosys on March 3, 2009

Got hit by this bug in SQL Server – the client had an update trigger that joined the internal tables (Deleted and Inserted) and when an update statement was being fired, it was taking a very long time.  You can read more on this KB article here.  If you are on SQL Server 2005 + SP2 and before Cumulative Update #12, you can face the same issue.  The client is still testing SP3 so rolling that out is still a week out but it is good to know that this is a known issue and a fix already exists for it.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: