Pardon me, if im not sure how to title my topic correct, i hope i can explain it clearly here.
Here it goes, we are using SQL 2005 and we have 2 client PC connecting to it. Both PC are using windows XP OS.
I've installed the same program for both PC, but when they try to retrieve the data from the server using a particular report, 1 PC can display the information, while the other one dont display anything.
I've performed an SQL profiler to see what went wrong.
What i gather was that 1 PC, was sending the query to the server with the date format 'May 17, 2013' while the other PC will send to the server as '2013/05/17' (btw server regional setting is DD/MM/YYYY).
I thot both date will get me a result, but when i try to run the individual query, the query with 'May 17, 2013' works fine, but the other query with '2013/05/17' will give me a 'out-of-range' error, but if i swap 05 and 17 it will return me the same value as the 1st query.
Now i was wondering how come the 2 PC, doesn't reflect the same date format, i've connected using the same login.
Appreciate if any can help me on this issue, as i've cracking my head on finding one. Any help or advise will greatly appreciated.