Might be useful to state which SQL version, as some estates have several versions available.

Btw, isn't sys.dm_exec_cursors the only DMF, the others are DMV's?

I went with the only function as...

I thought that SQLH2 Performance Collector dealt with performance counter related data? As it is a separate component from SQLH2, as the answer mentions performance counters, it could be argued...

Not a big DW user but I'd presumed what I had learned was accurate. Are we saying that MS are incorrect?

http://technet.microsoft.com/en-us/library/ms174806.aspx

Hmmm...

Ok, adding the sp_OAMethod calls to the calling procedure appears to have resolved the problem. This doesn't explain 'the why' as the initial 'Header' write is successful with the called...

Yet another poorly researched question.

ANSI_PADDING should also be a correct answer:

http://msdn.microsoft.com/en-us/library/ms187403.aspx

In a future version of Microsoft SQL Server ANSI_PADDING will always be ON and any applications that explicitly...

Ambiguous, and nothing to to with case whatsover. Is it me or is there a growing trend for such 'dodgy' questions posted with the sole intent of annoying people rather...

I checked this on MDSN as I presume I'd been previously misinformed and note:

[http://msdn.microsoft.com/en-us/library/bb934049.aspx]

Transparent Data Encryption and FILESTREAM DATA

--------------------------------------------------

FILESTREAM data is not encrypted even when TDE is enabled.

The truth...

Yes you can!

http://technet.microsoft.com/en-us/library/bb964719.aspx

The question neglected to mention any enterprise specific elements bring present, as a result the answer should be YES.

Trevor.

Clearly for nvarchar the answer should be 4. I have even taken the liberty of running the code just to make sure I'm not losing it.

Cheers.

Trevor.