I'm so used to the output of 1204 that it's not a challenge to read anymore. Could be that this is not a good thing.

Is the output of 1222...

Do you have a previous database backup?

Run the following and see what it says.

DBCC CHECKDB ('MyDB') with no_infomsgs

Ack. That should be the very last resort when all else fails, not the first thing to try.

The system tables should not be updated. Doing so can have nasty consequences.

It's a fairly big topic. Books online has a good coverage. Have a look through that, then if you have specific questions, post them here.

Yup. And that, along with the...

If yu're using SQL 2005, you should avoid extended stored procs. They are deprecated. use CLR instead.

What does your extended proc do?

Is that account in the local administrators group?

Are you sure something else isn't connecting in? SQL Agent, MOM, anything like that?

Sure it's necessary. CheckDB checks to see if there's any corruption of any form in the database. Invalid checksums, bad page linkage, out of range column values, etc

I would suggest...

You can also use profiler to detect deadlocks, but it requires running a constant trsace, which I prefer not doing.

Fixing deadlocks is a pretty wide topic. Generally bad code is...

Yup, and it does work. Had to do that a couple months ago after someone removed builtin\admins without adding the DBA's windows group first. :hehe:

Shut down the SQL service (and...

Probably compatability mode. What do the following queries return?

SELECT @@version

exec sp_dbcmptlevel < Name of the database you're in >

If you expand out the server in enterprise manager, can you see the system databases? Can you see the user databases? If you can see the user database, is there...

You can use SQL Profiler. Trace the event T-SQL Batch completed and take the start time, end time and duration columns. Duration is in microseconds.

Are you trying to find deadlocks or blocking? They're fairly different things.

To find blocking, you can use the sys.dm_exec_requests or sys.dm_os_waiting_tasks DMVs. Both have a column that will show if...

Please don't type in full caps. It's the online equivalent of shouting.

Suspect in system tray? Not quite sure I understand.

If you open enterprise manager and connect to the server in...