i guess i just do not understand why sql server thinks that a column with the same name, one with no trailing space or control character and one with nothnig...

Found this w/ Google:

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/c5442c34-3160-4084-bfc3-ac64e71aa907

HTH,

Rich

randheer, I thought I'd add some additional comments as to why I prefer RS over CR, beyond those listed elsewhere in replies to your post:

- Simplicity of design environment. ...

While I use both and...

Great! And thanks for posting back -- always good to hear that we helped you out.

You'll be happy you have that table, some day. Maybe you'll use it...

I cannot figure out the mumbo jumbo that MS puts out for with all their brackets and squigly characters for altering a table column. You need a PHD to...

I don't know that this is the preferred way to do it, but when I need a summary email with multi-step information, I often first create a table of errors...

Interesting article, Steve, and certainly of great financial and personal significance to millions. But I'm not sure this is a technology or database issue -- at least not strictly....

Gail, a minor typo:

In full recovery model transaction log entries are kept for both database integrity and database recovery purposes. Inactive log records are retained in the transaction log until...

WayneS (10/24/2010)

---

Anyone know of a good reference that tells how to expand a VMWare Workstation 6.5 virtual disk file, and have it properly show up in an XP guest OS?

I...

Hmmm, good point. I was thinking that if the...

Douglas Osborne-456728 (10/21/2010)

---

All,

I came up with this little trick - run the query

SELECT Name AS [Constraint], object_name(parent_object_id) AS [Table]

FROM sys.foreign_keys

WHERE Is_Not_Trusted = 1

then run this

SELECT 'ALTER TABLE ' + OBJECT_NAME(...

If you want to be a great manager, remember a few things - if you inspire your people to be their best, and facilitate their path to that end, YOU...

One thing I learned is that the accessibility to the report run history is embedded in the ReportServer DB tables. I realize this is only a small piece of...

With all...