There was a version...

GilaMonster (3/8/2011)

---

What...

Thanks for the update, and a good catch.

I might set a script to do all these things before and after the DR test, so that you have a set start...

I agree with Grant, follow Gail's advice.

If that's it, please let us know.

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/