Using the alter table ???? disable trigger ???? is totally crap. Shouldn't the trigger fire when some other procedure executes for which it SHOULD fire?

I have implemented the same effect...

If the variables are going to be used later in the procedure anyway, then what is the harm in fetching all variables in one place and use those where ever...

Chandu, here is a script that you can run to compact all the databases and their log files in one go.

*****************************

declare db_cur cursor

for

select name from master.dbo.sysdatabases order by name

declare

Thanks a lot.