difference between 2 SQL servers

Question

Post reply

difference between 2 SQL servers

ran.ovadia

Ten Centuries

Points: 1183
More actions
August 19, 2010 at 3:24 am

#226382

Hi,
I am running the same SQL select query in 1 SQL server and gets output of 1 row (e.g: abcd " efg)
In another SQL server which is refrshed from the first one, the same select output is:
abcd
" efg
2 lines instead of one.
Does anybody have an idea?
Thanks,
Ran.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

crazy4sql SSCoach Points: 19590 More actions · Answer 1

what are your select query and output format

----------
Ashish

Amit kulkarni-491236 Default port Points: 1492 More actions · Answer 2

Before posting any question please provide the details of the table and data and then the query. Just specifying that query is running differently will not help us in finding the solution.

Thanks,

Amit kulkarni

ran.ovadia Ten Centuries Points: 1183 More actions · Answer 3

OK, thanks and sorry.

Query:

Select description from table1 where id = 9992

crazy4sql SSCoach Points: 19590 More actions · Answer 4

and can you please check in both server, query output option is selected to same format.

Either to grid or to text

----------
Ashish

ran.ovadia Ten Centuries Points: 1183 More actions · Answer 5

In both the result is the same... I tried both (grid and text).

crazy4sql SSCoach Points: 19590 More actions · Answer 6

if the values in tables stored in similar way in both the server then its definately some setting which is changing he view.

Which sql version you using??

----------
Ashish

ran.ovadia Ten Centuries Points: 1183 More actions · Answer 7

ran.ovadia

Ten Centuries

Points: 1183

August 19, 2010 at 4:07 am

#1208978

Same SQL 2005 server with the same product version.

Derrick Smith SSChampion Points: 10833 More actions · Answer 8

Check the ANSI server settings

edit: This is weird and I think there's some missing info. Can you post a screenshot of both results please?

ran.ovadia Ten Centuries Points: 1183 More actions · Answer 9

Hi, thanks.

Do you know which ANSI can be related to? how can I know what are the settings defined on each server?

Thanks,

Ran.