Not sure if C: is the correct location to put SQL files as you are then sharing the disk I/O with the OS.

BUT one way you could do this would...

Looking at it, it is because you are comparing VARBINARY to VARCHAR.  So SQL is implicitly converting your VARBINARY(MAX) to a VARCHAR and VARBINARY 0x0A2E0A is not the same thing...

You cannot "trick" it; CSV is unformatted data.  Excel is trying to be helpful because it THOUGHT it was a numeric value.

I don't think there is any way to convince...

Not sure if the characters after the period really matter.  From reading up on the telnet email approach, I think the mail server is just looking for a line that...

Probably, but  I don't know RegEx very well and I often get it wrong so I prefer to avoid RegEx.

Also, I don't think SQL Server handles RegEx natively.

Do you need...

That would miss it.

You are getting 0A0A2E0D0A  so 0A (CHAR(10) 0A (CHAR(10)) 2E (period) 0D (CHAR(13)) 0A (CHAR(10)) which is weird to me.

One way (that is a pain in the butt but reliable) would be to cast the string as VARBINARY.

I recommend doing it with selecting the text and have the varbinary...

If the prefix and suffix you are wanting to remove are static known values, then probably the easiest way to remove them is with REPLACE:

REPLACE(REPLACE(column,'ZZZ ',''),' (left)','')

I...

Possibly a dumb question but would it be faster to do this on the application side?  Not sure how much data you are pulling (in MB/GB) if you just did...

If it is related to parameter sniffing problem (which it sounds like to me, but I also would not be surprised if I was WAY off on this), adding the...

One thought on how to "fix" this (based on the reply to the thread you indicated) would be to have that column returned inside a CASE statement where you could...

Anything interesting in the logs?  That is usually where I start all of my troubleshooting.  SQL Server logs as well as the Windows logs.  Never know where it may be...

I was doing some digging into this and best I can tell there is no way to do it without looking for a "\" in the ServerName field. And this...

I would recommend running a chkdsk on it (and DBCC once you get it online).  It could be that there was some corruption on the file/folder around permissions.  So when...

phpmyadmin, if I remember right, is an administration tool for PHP.  This, if I remember right, does not care about your database.  I think it can connect to a database,...

• This reply was modified 4 years, 7 months ago by Mr. Brian Gale.