Like this:

Select * from TABLE1 Where COL1 Like '___NDM%'

(note: these '___' are 3 underscores)

Actually, I can not see why you even need a transaction for this. If everything is in TempDB anyway, why do you need Transactions, Commit or Rollback?

There is nothing in SQL server called "Packages". Perhaps you could explain what they are and we could tell you if it exists by a different name.

Yes, it will be published on Tuesday, August 5th, I believe. Unlike Jeff, my time machine is broken so I do not have a pre-publication link for you. ...

Immediate Updating can contribute to distributed deadlocks like you are seeing. If you are going to stick with Replication, then I would recommend either switching to Queued updating or...

This is generally credited to Jerry Rubin, not Charlton Heston. and certainly not in...

I don't know about threading and SQLCLR, but I do know that you can do this with Linked Servers and Service Broker.

MrBaseball34 (7/30/2008)

---

UPDATE ptAppointments SET resource = I.resource + I.site FROM inserted I

WHERE ptAppointments.PID = I.PID AND

...

jcrawf02 (7/30/2008)

---

So, for someone who is using 2000 still, but looking forward to 2005, EXCEPT will let me intersect the two sets, and give me the results that are not...

I am sure that many people here know how to, but you haven't given us enough information to be able to help you. For instance, why couldn't that other...

MentalWhiteNoise (7/30/2008)

---

hmmm... interesting concept. "SQL Brain". I wonder though, instead of storing facts, could we (if given infinite processor and infinite storage) create a database that mimics the structure and...

Hmm, I seem to recall that...

Try the Log Shipping section of Books Online.

I agree, Jack. They're not even hard to use, in fact I just key them in by hand.

pensor (7/30/2008)

---

I used procmon.exe to break down the individual threads of the exe. I didnt recognize anything strange but will admit it sure was alot of information. None of the...