If you had enforced stored procedures for table access, then you could do it there.

NULL is not a value and NULL is never equal to anything, even another NULL. Thus:

On NULL = NULL

will Never match.

To get around this, you...

It is impossible to assign a fixed number or even a fixed range as right or best, because the best number of indexes is entirely dependent of design and usage.

One...

Actually, I think that there is like six Glasgows, in different states.

I tried it on my laptop and it finished in nothing flat. True, its just a laptop, but I do have over 30 databases.

At the very least, put it in tags so that it keeps its formatting.

Well that looks like a substantial improvement, Jeff. On my system it went from 32 minutes down to 27 minutes.

Hmm, I thought that this is what I already tested, but sure, I'll try it just in case it isn't...

barunpathak (3/28/2009)

---

I thought I explained it in detail (atleast I thought I did). Here you go again....

We have AS400 ERP system. From the ERP to the stage tables in SQL...

Yeah, I discovered that the prettifier works OK outside of the code windows....

I think that Service Broker is already on in a Mirrored DB. It probably will not let you make a NEW service broker because that would kill the old...

Florian:

I would not recommend using CONTEXT_INFO for this (or anything that I can think of). CONTEXT_INFO has no namespace or transactional control so as soon as more...

If you just merge the two triggers together, it will not trigger itself unless you have Recursive triggers enabled.

So how did this work out for you?

thulani: How did this work out for you?