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.

 Current...

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...