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

First thing I noticed is that it looks like you need to add another element here:

NULL AS [Profile!3!EVPersonalFunds!element],

NULL AS [SiteOfActivity!4!siteofactivityname!element],

You want it to be something like this (and of course,...

That's a great idea and what a service to the community. I'm not a big fan of reinventing the wheel. Having all of that readily available is about as close...

The basic syntax will work in Oracle, but you can't have the brackets.

Since I know just how HORRIFIC the XML EXPLICIT statements can be, I shudder to say this, but go ahead and post the query (maybe as an attachment) and someone...

I don't believe the CREATE TABLE scripts can be made generic, but I could be wrong. As to the INSERT scripts, just be sure you're, for want of a better...