First try running DBCC CHECKDB(). From the sounds of things, that'll probably fix it. If not, you've got work to do. Can you restore it from backup? If not, you...

And wrap it all in a transaction.

Also, make sure you include the old data values in the update statement. That way, if the second call manages to get the same...

It's already in the script, but it doesn't look right to my (very untrained regarding PIVOT/UNPIVOT) eye.

A deadlock is when two processes are in contention for the...

I think you mis-pasted the results there. You should see a session_id. I know you can identify the blocked session id. From that, you look at the wait_type column to...

Good one. I hadn't thought about looking at the cache.

You're getting wait states, or contention in your system. For a quick & dirty look at what's happening, query the DMV sys.dm_os_waiting_tasks while the suspended status is going on. That'll...

Is it "as unvpt"?

I'm not very acquainted at all with the PIVOT & UNPIVOT operators, so that's a guess.

You can automate the use of SQL Profiler (also called Trace) either by using the correct stored procedures (sp_trace_create is the first of many, look 'em up in the BOL)...

Actually, SCOPE_IDENTITY should work perfectly well in the way you've described it. Is it possible you're getting insert errors, deadlocks or something, because that would cause bad results from SCOPE_IDENTITY.

From the description, you did not detach the database prior to removing the files. There are still entries for that database in your master & msdb databases. Trying to reattach...

We're doing all our new development on 2005, but we haven't even started a plan for upgrading from 2000 because, like you, everything is working fine. Our current assumption is...

In addition to what everyone else has suggested, I'd also suggest taking the delimited list that you start with and instead of using it to load up a temp table...

I just have to...

That is usually seemless. What collation is set on that database?

BTW, if you're data in the database is nvarchar and you use varchar in your parameters or what have you,...