All the ones I know about cost money.

Programs -> Microsoft SQL Server 2005 -> SSMS

Be sure you installed client tools. This is not required, so if you don't have the group, run the install again and just...

I have friends with Virtual SQL Servers (under vmware ESX) on blade servers. not sure if these are HP or IBM, but they are SAN connected to avoid IO issues...

I don't trust block level, and here is why.

Suppose I have a large transaction and it updates blocks 1-100. In the middle, I have a failure and blocks 1-99...

I don't think you have any space savings.

On the multiple sizes, there are places that store 1 or maybe 2 and then resize on the fly. Web servers are...

What was the reason the database was suspect?

You could try attaching the mdf with no ldf and see if can rebuild it.

Logins will be in master, and you need to know how to restore this. Jobs in msdb, make sure you know how to recover this.

you might have IP/windows server name...

There are lots of scripts in the scripts section of this site to do this. Put this in a stored procedure and call that from the job.

Call microsoft PSS. There aren't good tools for the DBA to fix this and you don't want to mess with your data.

You can try rebuilding the clustered index, but if...

Yes and no

Model is used for all databases, including tempdb.

you can expand tempdb and it will start there on the next instance restart.

Very interesting and I wish I had an answer. This almost seems like the RESEED is scanning the huge table which has been marked for truncated, but not truncated.

Sounds like...

Get a SQL Server 2005 book and read through it. It's ordered, logical, and gives you a framework.

If you're managing servers, get backups/restores down. These are important. I'd agree Security...

http://sql-server-performance.com/Community/forums/p/346/3038.aspx

I suppose you could export the data from the msdb tables (sysdbmaintplans), but the problem is these plans have so much stuff connected to your server. They're not as generic...

Is he mapped to DBO or does he have dbadmin rights?

The tables are still likely created under his name if the former. You can use sp_changeobjectowner to fix this.