Matt,

yes my bad. We have standardized using the DATALENGTH function which takes into account all bytes thus having to trim trailing spaces, if so desired.

Another way to lose any leading or trailing spaces....

select column from table where len(ltrim(rtrim(column))) > 6

Are you using SSRS on any of your instances? You will lose the Data-Driven functionality.

Well SQL Server 2005 still must use an 8K data page. There are work arounds as using large datatypes, but you must realize how sql server 2005 handles that. It...

Scott,

I have found that creating Data-Driven subscriptions can give you alot more power as to how you can publish to a file share situation. That way you can create a...