ASDB database is huge!

How do I reduce it?

[AWildman]

Okay, first off, am I correct in thinking that the asdb database is the transaction database for all the databases in MSSQL?

Second, how can I reduce the current size? We can limit the growth size down the road, but how do we reduce it right now and what are the affects? I'll assume that I'd lose the ability to recover database transactions from the rows that are removed, but beyond that, should I be okay?

[TheNige]

Did you look at the tables in ASDB? TempDB is where transactions get stored in SQL Server as far as I know.

[AWildman]

I did look at the tables in ASDB, but I don't have a complete grasp on exactly what it is.

Can this TempDB table simply be removed or emptied to free up space?