I must admit I am somewhat ambivalent to storing XML in a relational database.

If I am going to store XML data it is because I want to retrieve it in...

From past experience I would say that budget constraints make a proper test hard to carry out in many shops.

You may be able to proove that a backup can be...

Which is which?

Thhe version of BOL I mean not the Bible. I'm not opening up that can of worms!

I don't really have any more to add than what is in the post. I need to pin it down further before I have enough to go into an...

BOL isn't the most accurate set of documentation on the planet!

Use Thunderstone's Webinator.

I used it on http://www.adviceguide.org.uk and http://www.citizensadvice.org.uk

SELECT @dtStoptime = CONVERT(DATETIME,CONVERT(VARCHAR(11),GETDATE(),120)+ '23:59:59.999',120)

SELECT
    ID,
    ISIN = MAX(CASE ALTERNATE_TYPE WHEN 'ISIN' THEN VALUE ELSE '' END) ,
    BARCODE = MAX(CASE ALTERNATE_TYPE WHEN 'BARCODE' THEN...

You have to register your COM component on your database server and not many DBAs are keen on this.

You need to be sure that your COM component is well written...

On SQL2000 you need to avoid XML.

It uses MSXML3 where as the most recent version is MSXML6

The only way that I can think of to do what you are expecting...

look up DBCC CHECKIDENT with the RESEED option.

Avoid XML like the plague.

If you are using BCP there is command line parameter that lets you specify the batch size for each transaction. I tend to set it...

The are effectively a point-in-time template, so although you define a user-defined datatype for a non-nullable integer with a default of 1 this only applies when you create the column...

Was Betamax a failure?

Technically far superior to VHS and much more compact and yet due to market forces it was eclipsed by VHS.

Similarly the last European Ford Escort sold by...

If you have a development server I would test your system thoroughly on that.

I took the opportunity to run a DBCC DBREINDEX when I upgraded some databases to SQL2005.

SQL2005 is...