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

This being the SQL Server 2005 development board, and your question being about connecting Access to SQL Server 2000, you might want to post it in a different forum. Start...

Assuming both databases are on the same server:

INSERT INTO DB1.schema.table

()

SELECT ...

FROM DB2.schema.table

Andy,

Thanks so much for posting this. Ever since I heard about the event I've been wondering how you went about pulling it off. It's something I'd like to see our...

We do this sort of query quite a lot. We've found that we use one of two patterns, one works well for a single row, one works well for multiple...