Chris,

There is another way to minimize your transaction log when you run from dts, if you open your dts package and right click anywhere, you can see the package properties...

I would go on the server and check under system tools to see if there are any scheduled tasks that automatically shuts down the service.  Lately our server which we...

Bill,

Sounds to me you might have a server level schduled job that stops the mssql service if you're sure no one has done it manually.

Ishaan99,

Is there a reason not to use the SQL Litespeed GUI?

Is your dts package password protected?

Ishaan99,

Is there any reason why are not using SQL Litespeed's GUI enterface for the restore and have you tried it?

Judy,

If you noticed how Mordechai used the convert and cast functions in his script to get the accurate calculations of time.  The sysjobhistory datatypes for their run_time and run_date fields...

Can you post the resto of your script?  Where is the part where it executes the shrinking?

I totally agree with avoiding cursors, they are fun only if you have a table with limited rows of data.  Try running a cursor with millions of records and you...

Donna,

There is a free software Lumigent Schema Alert, it will notify you if objects are dropped.

Is this something new or has xp_xendmail been working and all of a sudden it stopped working?

Going to a SAN environment is like the latest technology if you're comparing it to local disks, this consultant must not know too much about SAN.

Bryan,

rsharma posted a script for info on indexes, I think it would help you.  Under sql server admin:  5th thread.

Jules

If you run dbcc showcontig, it will show you the info for each table.

Papillon,

If you are not running transaction log backups, I suggest you setting your db option to simple so your log files do not grow in time and SQL Server will...