Backing up the transaction log shrinks the active portion (I believe - I'm new at this). Have a regular t-log backup in your maintenance plans.

Thanks, that's cool.

There are other Xtypes in the sysobjects table, does anyone know what these are? They are D, FN, P, S, TF, U, V, X.

Where do you...

I cant figure out how to do it with DTS. Actually its the DTS

packages I'm trying to move, and it wont let me select the

sysdtspackages table from the...