Two other options:

Copy the table into newtable. This is something I like to do prior to making changes to it. It is not a backup per se, but...

Thanks - looking forward to hearing back on the results.

I just ran across this blog post. I think it could be useful.

Mani-584606 (5/4/2010)

---

Those objects do not appear to be doing much. Have you been able to trap the query yet that is causing so much activity?

I would set up the sql...

You're welcome.

Mani-584606 (5/4/2010)

---

Thanks

Query1:

use tempdb

go

SELECT OBJECT_NAME(id), rowcnt

FROM tempdb..sysindexes

WHERE OBJECT_NAME(id) LIKE '#%'

ORDER BY rowcnt DESC

Results:

328 row(s) affected)

#5629CD9C0

#58DCE86C0

#59511E610

#5A45429A0

#5BB955170

#5BB955170

#Temp_______________________________________________________________________________________________________________0000000046480

#Temp_______________________________________________________________________________________________________________0000000046480

#5CECA51B0

#5DE0C9540

#5E15D37E0

#5E95C1C20

Query2:

DBCC OPENTRAN('tempdb')

Results:

No...

or is that tratmentitation?

Interesting solution.

Thanks for the article.

I also like the additional points of Interest that Paul has raised. They bring a good amount of education as well.

You are welcome.

And not some lame short blog post - must be article worthy!!

I would like somebody do an entire blog post via twitter:-D

Brandie Tarvin (5/4/2010)

---

wodom (5/4/2010)

---

I don't know. Haven't been able to find out. We're supposed to download it...

Or for 2005, try this:

SELECT [Spid] = session_Id

, [Database] = DB_NAME(sp.dbid)

, [User] = nt_username

, [Individual Query] = SUBSTRING (qt.text,

...

Nice program and good luck to all entrants.

A 5Tb stick would be great. Imagine all of the...