Matt,

The only problem with LTRIM(RTRIM(column)) in comparison (WHERE or JOIN) clauses it that you no longer give the optimizer the option to use an index seek, the best it can...

Check out this article, Custom Error Handling in SSIS[/url], which contains a link to an earlier article that I wrote. Both expand on what Grant mentioned.

What application are you using to run the query?

While you will be better off with SCOPE_IDENTITY() in place of @@Identity you need to be aware that there is a bug in SCOPE_IDENTITY(). See this post.

With 2005 the...

I'm pretty sure that it is individual DB...

Whoa! That is a bad idea. By making the users System Administrators they now have the ability to do ANYTHING they want to any database on the server.

I'd...

Wow, if you get this working be sure to write it up. I'm not sure I'd ever use it, but I'd like to see it in action.

Okay, that helps. I'd start with call to the vendor, assuming you have some support. The problem is definitely in the report definition on an object that has...

I'd think you would need to re-run the SQL Server client tools install and make sure Report Model is included.

You need to provide some more information. What is the expression? How are you retrieving the data? Is the source of the data SQL Server?

I used to live in Northern New Hampshire where I was at least 2 hours from the nearest events, usually more like 3 or 4 (Boston), including user groups. ...

No problem. You made me curious so I had to do something.

Hey, I ran a Profile trace and then scripted out a table definition as that gets you the settings. The setting for ANSI_PADDING is in sys.all_columns is_ansi_padded.

Lynn,

Interesting question. I have no idea which hire negotiated the higher salary. Without knowing a bit more, # of previous companies worked for, did one or both need...

What do you mean by user? The ANSI_PADDING setting is one of the connection string settings and with SSMS and ADO.NET it defaults to ON. In SSMS you...