Developer edition includes the agent and there's no way to install the db engine without it been installed as well. (I tested that out yesterday)

Is that the version of your...

A case statement should do the trick.

I don't think I want to know what the DB looks like. I do wonder what account the web site was accessing the DB with.

Drop database .... ?

Severe overkill. 😉

Reindex completely rebuilds an index and updates the statistics with a full scan.

Reorganise shuffles leaf pages of an index into order. If the index has just been rebuilt,...

That's what I'm thinking. Though I hope that a 24/7 heavy transaction system is not being run...

That's not the case. There's no requirement in SQL server for a table to...

Not that I can see. I jsut ran the installer. I can't see an option to not install the agent. If the database engine is installed, it is automatically installed...

Pleasure.

Why do you need to reinstall SQL agent? What's the problem?

Primary key never affects the row order in data pages. It's the clustered index that does that. Now, by default the primary key is a clustered index, but that is...

Are there any triggers on the table?

Switch traceflag 1204 on (DBCC TRACEON (1204,-1)) and the deadlock graph will be written into the error log. That'll give you a lot...

I believe in SQL 2000, you require sysadmin to use that function, and I don't think there's any way around it.

In SQL 2005, the ALTER TRACE permission was added so...

The admin tool is Enterprise manager, but as already noted, it's not installed on the server. Are there any DBAs there who might have that installed?

The SQL Scheduler is SQL...

MCDBA is SQL 2000. The SQL 2005 certifications are the MCTS (SQL Server 2005) and the MCITP (SQL Server database Admin) and MCITP (SQL Server Database developer)

The link I gave...

That's correct, but you also will only be able to restore the database using full/diff database backups.

If you take a full backup at 7pm and the next day at 5pm...