Now that you found a trigger - it sounds like the trigger was created assuming that it would only run into single record updates. If it's written in that...

Not sure what would be so "unstable" or undesirable about it. It works the way it's supposed to. The global table variable doesn't seem to buy you much...

If I may ask - if you're storing a date value - why would you store it as anything other than a datetime? storing dates as character or numeric...

Double posting.... Conversation continues over here:

http://www.sqlservercentral.com/Forums/Topic466857-149-1.aspx

The linked tables need to be set up with a set of fields that can uniquely identify each row in order to be updateable. If you haven't done so...

Jeff Moden (3/10/2008)

---

Ok... once you learn how to use a Cursor, THEN avoid them as if they were Leprosy 😉 There is very very little you actually need a...

If you have an extensive data structure - then it may be necessary to bering someone in to help you do it. The last thing you want is to...

Sam -

this is one of those times when the error message is actually telling you something accurate. The advice is to change your growth factor to a fixed...

One single run of the loop will "wipe out" all rows created after 1/5/08. If that's the two million, then yes - one single run will handle them all....

If you ARE on 2000, you can use SET ROWCOUNT instead.

Meaning -

....

SET ROWCOUNT 10000

While 1=1

Begin

Delete...

You're going to have to give us more detail than that in order to help you. Try to give us the table structure and the criteria of the clients...

Do you have any open transactions? It can only truncate up to the more recent uncommitted transaction.

dbcc opentran

jay holovacs (3/10/2008)

---

Jeff Moden (3/10/2008)

---

So far as the cost of a DBA goes, I think the reason why Oracle DBA's get paid more is because of perception. I think...

Open up your web.config file (from within the project editor). do a find for the old database name (it's in the connection string for the data). Replace with...

Lynn Pettis (3/10/2008)

---

If discounts have to be applied in a specific order, it does add to the complexity. Ten percent off of ten percent off, is not twenty percent...