July 15, 2009 at 2:52 pm
Hi,
I have SQL 2008 DB and the functionality is using ADO.net client. When I load the data from SQL 2005, it gets traling spaces however, when I load it from SQL 2005, it does not.
Is there a setting that controls this? ANSI_PADDING is off on both the databases.
Please advise...
OR let me know how to compare configuration settings between these two servers and the databases.
Thanks in advance
July 15, 2009 at 3:14 pm
How are you loading the data? Or querying it, which is what I think you mean.
You can compare the default session settings in SSMS as well. Right click server, properties, see if there are different settings.
July 15, 2009 at 5:08 pm
Are you sure the column definitions are the same? Could one be varchar and the other char?
I would recommend using Redgates SQL Compare tool to perform a schema comparison between the two databases. That will help identify these kinds of issues.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 16, 2009 at 5:30 am
The DB is restore of a SQL2005 version on SQL2008 so schema is same. Still investigating whats wrong. I suspect some server level setting is causing this issue, however, ANSI_PADDING setting is same on both the servers.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply