Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
r-bart
Starting Member
1 Post |
 Posted - 2010-11-18 : 05:45:31
|
| hi everyone,please I need help. I have two almost identical sql servers and application that has to import data from text.DAT files via BULK INSERT. the problem is converting date into column DATETIME formated. source data is in CYYMMDD format. The aplication imported data correctly on one server but on the second one imported date data is not formated properly. both sql servers have the same collations, the same database, and I think they have identical regional settings.any idea what else shall I check or compare to find the diffrences?many thanks for any suggestions. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2010-11-23 : 16:35:43
|
| Have you considered the SET DATEFORMAT setting?=======================================No matter what side of the argument you are on, you always find people on your side that you wish were on the other. -Jascha Heifetz, violinist (1901-1987) |
 |
|
|
|
|
|
server settings