Sean Lange (3/7/2011)

---

Another point about maintaining a system with encrypted stored procedures. If you do not keep the original script in source control you run the risk of not knowing...

Then something went wrong with your import somewhere and the spaces were lost. Can you not do this?

update trlc

set weight = ' '

where weight = ''

The protocol used is dependent on the client and server. It's possible that you have this client using named pipes and for some reason it flakes out at times. It's...

I'll forward it on. We do some image resizing in javascript, but it seems to work for most people.

space is considered a byte.

Is this 0?

select datalength(weight) from trlc;

Is there more than one row, so you should be getting a whole series of values here. Are they all...

It's not quite clear what you mean from the description you have written, possibly because of a language barrier.

Do you mean that there are not records in the related tables?...

It works fine here in FF, Chrome, and IE 8.

This page isn't any different than any of our other pages from what I see. There are flash items and images,...

They work for me. If they are returning 0, then you have 0 bytes, no space in the field/row.

LEN ignores trailing spaces. A single space is a trailing space

http://msdn.microsoft.com/en-us/library/ms190329%28v=SQL.100%29.aspx

Use DataLength instead.

http://msdn.microsoft.com/en-us/library/ms173486%28v=SQL.100%29.aspx

The code above is good if you know how many rows you'll get. If not, you might look up PIVOT or cross tab queries to see if they help.

Could be a bad plan, maybe some parameter sniffing, or even something else.

Did you read this? http://www.sqlservercentral.com/redirect/articles/72634/

Are you trying to append to a file? Or perhaps permissions? This is an OS level error bubbling up. Either paths are wrong, permissions are wrong, or maybe the file...

This isn't quite clear. Are you saying that you have full backups of multiple databases in a folder and you want to restore these backups to new copies of the...

So I'm slightly confused. You have marked the two rows as duplicates with separate conditions, but the second one doesn't make sense. Are there other duplicates? In this set, which...

Out of my area, but I'll ask a few people if they know and get you an answer. Glad it's working.