to attach the database, copy the files to the desitred location and use the following T-SQL

sp_attach_db 'dbname', 'drive:\path\filename.mdf', 'drive:\path\fiilename_log.ldf'

oh OK. There are advantages and disadvantages of both, the following link details rebuild vs drop and create

http://msdn.microsoft.com/en-us/library/ms189858.aspx

couldnt agree with you more

i seem to remember this. The first release MS made of SQL 2005 SP2 had a bug with maintenance plans. Get the latest version of the SQL 2005 SP2 and...

thats the way i understood it to be

in perfmon under Memory check "available bytes" too.

i could be wrong but i get the feeling he was trying to achieve it without the use of a cursor

BOL implies this is done on a transactional basis not a time basis?

SET @DBName = ''

WHILE @DBName IS NOT NULL

...

check this info on recovery interval option

http://msdn.microsoft.com/en-us/library/ms191154.aspx

checkpoints occur for a number of reasons

what are you shrinking data files or log files

SQL server will not shrink past an active portion of the file, if that happens to be near the end of the...

or choose script to new query window then close it and save as .sql script

local temp tables should normally clear up when out of...

and consequently the overall file size.

it would be interesting to see what happens...

assuming he is seeing a public IP address, my guess is he isn't