WayneS (1/23/2010)

---

P Jones (1/22/2010)

---

Bet that's the...

😀

D.Oc (1/23/2010)

---

Oh, now...

In what...

There's a lot more than just teeth that your lions don't have 😛

There is another scenario that could be causing excessive use of the tempdb.

There is a poorly written runaway sql statement causing heavy tempdb usage.

There is also the possibility of a...

GSquared (1/23/2010)

---

CirquedeSQLeil (1/22/2010)

---

GSquared (1/22/2010)

---

There's a report you can get on schema changes. Deleting a table is a schema change.

Right-click on the database in Management Studio, and select Reports, then...

now i get to go home

but i get to work tomorrow too - woot

Ha - still going.

Jeff Moden (1/22/2010)

---

If I understand correctly, that may be the problem... no indexes on the columns you're working with.

If you could gen and capture an actual execution plan, I'm sure...

sp3 for SQL 2005 and sp1 for 2008. There is currently a drive to try to get sp4 for 2005 and sp2 for 2008.

Excellent, can buy my way through...

Please provide the table structure. It seems like there might be a datatype mismatch between the query and the table.

Have you tried appending Print statements at various points of the proc to determine where the proc might be failing?

is the proc returning an error code?

Holy chihuahua - still working.