I'm not sure whether it's still an issue with Win2003 and SQL2005, but I ran into a problem a few years ago with installing a SQL2000 service pack because I was...
If you're using SQL 2000, I believe DBCC CHECKDB will create long-running transactions (which will cause blocking). However, if you're running SQL 2005, DBCC CHECKDB will actually create a database...
Unfortunately, I don't think IIS Manager provides that information. However, you could use the Web Service object in Performance Monitor (each website is a separate instance). The following counters may help.
Scope_Identity() doesn't always work either; when you have an INSTEAD OF INSERT trigger, it will return NULL (in the example below). You then have to use Ident_Current() or @@Identity or...