Andrew

To me, that looks serious enough to raise a case with Microsoft and send them the stack dump. Other than that, maybe someone who knows more than I do...

OK, then this is only going to help with the one you posted. Do you have any other examples, please?

John

Andrew

Yes, you will get exactly the same problem if you're using the same script or maintenance plan or whatever to back up your databases. Like I said, this is...

Andrew

Do you have any other examples of Operating system error 170, please? Whenever you get an operating system error xxx message, go to a command prompt and type [font="Courier...

Andrew

The backup failure on T:\MSSQL10_50.sqlvault\MSSQL\Backup\UserDBs\EVVSGxxxxx\20140605_200752_EVVSGxxxxx_1_11.BAK - is that a backup that you have scheduled? At what intervals does this error occur?

John

Well, you won't know until you try, but I would guess that it will.

John

You need to use the splitter I linked to earlier in order to separate the languages out. Then you will be left with strings like this:

[font="Courier New"]US:"Project/Prescription sale"[/font]

The bits...

Yes. Do you have the option to use Windows authentication to connect instead? It's bad practice to do anything as sa.

John

Well, the language-specific description always begins at the 6th character, and ends at the (n-1)th character, where n is the total length of the string. You can use SUBSTRING...

Not sure which server you're referring to, but you can set up any old server as a CMS (has to...

If it's an option, I would create a table with one row for every combination of sale type and language. Then you can use a splitter[/url] and a little...

I wasn't aware there's a maximum length of script for the Execute SQL Task. What is it, as a matter of interest?

One alternative is to set up a central...

I only mean that you should do that as a one-off, in order to discover the ASCII number. Once you've discovered it (let's say it's 99), you can do...

Perhaps a variable in that part of the OPENROWSET clause isn't supported, although I can't find that documented anywhere. You may have to use dynamic SQL instead. Beware...

I don't know whether this'll work, but it's worth a try. Do it on a test server, not in production. Find a row in the table that contains...