Normally NULL's never match other NULL's, and this is the case when ANSI_NULLS is ON (the default). As far as I know, all indexes are built with this assumption...

Actually, I think that the problem is more likely to be your stored procedure than your trigger.

Are you using a cursor or a While loop to delete these records?

Please show...

Somethings wrong with your link, Jeff.

With Access, Opening a connection is fast, but corruption is a concern, so you open & close for each action/transaction.

With SQL Server, Opening a connection (relatively) slow, however, corruption is...

It has been submitted and is awaiting approval. As Jeff said, once it is approved it can still be another 1-6 weeks before publication, but I may be able...

heh, That would explain the yellow spots I keep seeing... 😀

😛

rbarryyoung (7/3/2008)

---

Here is a post that has as good example of a Split function that works very well. It use varchar(MAX) but you can change them to NVarchar(MAX).

As for...

Larry Huisingh (7/3/2008)

---

I've noticed that code in your articles have keywords color-coded. When I try to copy/paste from Query Analyzer or Enterprise Manager into Word I don't get the...

Here is a post that has as good example of a Split function that works very well. It use varchar(MAX) but you can change them to NVarchar(MAX).

As for the...

Well, actually, you can do it on the DB side, but it is a lot more trouble than it's worth.

I am doing this right now, but unfortunately, one of the things that I have learned about Service Broker is that it is hard to do anything "simply". There...

Jonathan Kehayias (7/3/2008)

---

This is not something that you should do with an assembly. A linked server can be created following the instructions in the BOL:

http://msdn.microsoft.com/en-us/library/ms190479.aspx

Then a DML Trigger on...

Woo-Hoo! Way to go Gail! :w00t:

What an excellent choice by Microsoft. What really strike me about Gail is the incredible precision and accuracy of her responses. Despite the...

GilaMonster (7/2/2008)

---

Not a bad...

Dynamic SQL.