SELECT Object_name(1307971836)

That's the ID of the table and is given in the header of the page

Two things.

You need to run a checkDB. Until you do, you won't know if there's...

That's not in anyway related to the build number and cannot be derived from it. SQL 2005 RTM (for example) is build 9.00.1399 on dev,...

What do you mean by edition?

RTM, SP1, SP2, CU4, ...

or

Developer, Express, Standard, Enterprise

Steve's build list is very comprehensive, though it doesn't contain every single KB that MS has ever...

If you're asking for the edition (developer, enterprise, standard), that doesn't match with a version number at all. Steve's got a list here that matches versions with the build numbers...

Not really. The thing is, the SQL engine needs to be able to decrypt the procedure in order to compile and run it, so you can't use some third party...

A trigger's not the best way of doing archiving. Rather consider having a job that runs once a day (during a quiet time) or once a week or however often...

What format's the deadlock info? If it's the text deadlock graph from the error log, just put it into a post. Otherwise zip and attach and explain what's in the...

Suspended indicates that the query's waiting for a lock (or other resource). Query sys.dm_exec_requests, see if the query is blocked, see if it's waiting on a resource.

If it's blocked, check...

The log will continue to grow until a truncate is issued, at which point the space within the file will be available for reuse.

You say the DB's in full recovery...

You'll be surprised. Very surprised.

Do a google search and see how many sites...

You said before it was an insert trigger. Need to know a lot more about what the trigger's doing before I can say anything more than I have on the...

Depends on what the trigger's doing.

Triggers run in the context of the transaction that was started by the statement that fired the trigger. That transaction is only committed after the...

You'll have to buy one of the editions of SQL server. I don't know if you can still buy SQL 2000 though. Without knowing what you're doing, I can't say...

No. SQL does not support files on raw disk. NTFS file system is best.

Shaun, I don't know who that was intended for, but changing the web page as rendered is not required, cross site scripting is not required, adding anything to urls as...