It will consume a bit, but you can filter down the events and columns pretty low, store the data on a file on a separate drive, etc. Use a server...

How is the data coming? IS it in SQL Server?

In 2005 there's a default trace (http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/), but in 2000 you would have to have a server side trace running.

why use xp_cmdshell? I'd script this outside of SQL (VBScript/Powershell) and have the data inserted. Then you can easily call this from SQL Agent.

I think Michael means most people don't think.

or a horse?

I came to the conclusion the Dash was very poorly built. A 6" drop broke one. I've seen iPhones survive multiple falls from 3ft+, so I have my...

Why is verify history needed? I've never used this on the same server since backups are usually known quantities. It's on a DR server I might check since I don't...

DTS doesn't have scripts. You build packages.

Any script can be run in an Execute SQL task, so you can put a script in there to reorganize or rebuild indexes.

You would install SQL 2008 as a new named instance.

Nothing to worry about other than you might limit memory for each instance so they don't overwhelm each other or your...

I think this is to work with char fields. Probably left over behavior from the past.

Moved to SS2005 forum

I tend to agree with Markus' advice.

Don't grant this advice to public, however, create your own role.

Have you tried drop database from T-SQL or just used SSMS?

It sounds like the client (TSM client) on the server isn't able to communicate with the TSM server. Perhaps a firewall/router issue?

Make sure NT Backup or some other process isn't holding the tape drive or accessing it.

It is not recommended that you back up to tape. I'd back up to disk...

Make sure NT Backup or some other process isn't holding the tape drive or accessing it.

It is not recommended that you back up to tape. I'd back up to disk...