I do love your pieces 'Phil'.  Always well written and gently humorous.  Being of a similar tinge of grey, the characterisations in your editorial are instantly recognisable.  I also hadn't...

Thanks for the pointer. Yes ONE of the solutions suggested on that page worked. Note that the suggestion to call:

EXEC sp_testlinkedserver N'DCN_SPREADSHEET';

doesn't work. That jumps the CATCH...

...and depending on whether staffid is supposed to be a literal or a variable, it either needs single quotes around it or to be preceded by @.

I agree with ProofOfLife - this has to be a security issue. However presuming that you haven't recently changed the account your SQL Agent is running under, it seems...

Hi Chay

Since my posting I have discovered the answer (or at least the answer that worked for my circumstances). The problem was the IIS setting 'Enable32BitAppOnWin64' (in the list...

I'm getting the same thing on Server 2008 x64 and from the research I've done, it does appear to be 64/32 bit issue. Unfortunately that's about all I've been...

Thanks Jason.

The improvement I've started on is rather than use pipe delimited placeholders in the various ExtensionSettings and Parameter values is to convert those two XML fields into table variables...

Jason your post on manipulating SSRS subscriptions says you've incorporated various of the suggestions made by other contributors and a later post of yours suggests that the amended version is...

Great - that was indeed the answer EXCEPT that I had to have 8.0 at the top of the format file rather than 9.0 (my output file had a 4...

Another option is to use CLR, even though not everyone is a fan of that option. The SQL# library that is available at http://www.SQLsharp.com/ has functions to...

For the purposes of experimentation I did so but really I'm looking for a...

Errrrrr this line is too long. You could've shown me at least the code

of the create table I would've believed you.

I've just tried even to dump the mp3 and...

If you do that bcp doesn't output anything it just displays the prompt:

Enter the file storage type of field FileData [image]:

which isn't very...

I'm also having trouble implementing this without corruption of the file after it's undergone a round trip. I am importing a text file using OPENROWSET and as far as...