It's very possible that this happened when the application was converted from Access to SQL7. It was a good find because it caused me to look through the DB...

Thanks all. I think the "couldn't make it work with delete triggers" is probably the answer. I took a look at a bunch of other tables and found...

Nevermind. The issue was caused by the FK constraint being enabled NOT by the constraint CHECK option.

If this is a one time deal, why use *? If you already know the columns, you can simply add a case statement to the field you want to...

Not sure how to do the Excel part. However, for a dynamic approach you could do something like this:

-- Create a table with the distinct values you're...

Any ideas? I thought this type of issue was hardware or power related, not data.

I'm using SQL2008R2

I didn't know the command was deprecated.

The issue has been resolved (see above) but this is an update.

ProcessMon is your friend. Seems that in Win Server2008 SQL Server 2008 R2 was impersonating the login that was...

Thanks, Jeff. I will really consider doing that.

The funny part is, early in my attempts to resolve this, I read many articles that said the issue could be related...

It IS interesting.

Basically, if the user running the script or procedure is a DB user, the network service account (or whatever the SQL Server is running as) does the work....

To anyone else who felt this pain here's the solution. First of all, ProcessMon is your friend. Seems that in Win Server2008 SQL Server 2008 R2 was impersonating...

Hi, Jeff. Nice to hear from you again as well.

I tried your approach. It didn't work but may shed light on the overall issue. I get the...

Thanks for the response. I've attached the execution plans.

I find it weird that the optimizer chose in both cases to use the non-clustered index for the seek. The...

No joy.

I'm wondering if it's caused my the domain permissions. I can create a public user with no special privileges on the SQL server and perform this operation with...

Thank you. I thought about that when I woke up this morning, that making the SQL call in a string will cause the execution to be done by the...