You can select this in EM, it's the bottom of the 2nd tab.

sswords, that quote makes the post above rather amusing.

Apologies for this. I have removed the article. If links are broken, that it why.

The query could be the Windows system service, it doesn't have to be inside SQL. The DOM wrapper is around low level code, not necessarily TSQL/TDS stream code. you can...

sure, add a new column in the proper place

select x

, y

, 3 'scalar'

, z

...

I haven't seen that. If you're worried, call MS, sounds like a problem anyway.

I wouldn't be that concerned about corruption. If it is doing cleanup, it should be logged, so...

You need to include the user name. Look up the syntax in BOL.

It should not. I have done this and I think it's a transaction, so it undoes the work done. Or maybe it just stops, can't remember.

That's strange.

sp_configure 'allow updates', 1

reconfigure with override

update the table

reverse the first two statements.

I had an issue similar with an AS/400 driver, but it was an amount of data that was being returned, xx bytes, before it cutoff. If you can select different...

Backup using a product like SQLBackup (Red Gate) or Litespeed (Imceda). they support encrpytion

Thoughts and prayers to those in London and their loved ones.

Apologies. This was submitted and I missed the database name. I've awarded back points for those answering C and fixed the question.

That's $200 an hour

Yep, apologies, this one is incorrect. It slipped by me and we had a similar one a few weeks ago.

According to the engine developers at MS, they both are instantiated...