I am having a few problems with importing date fields depending on whether the data is from a text file or an excel file ( with it's own column settings ).
I have reasoned that the solution lies with the default date settings in SQl Server (2000).
Using 'set dateformat', I set the format to DMY from MDY from my client. Using someone elses client however, I soon noticed that the setting for that client was still MDY. Further investigation told me that the connection properties actually override the server settings (including those set by the 'usp_set_start_options' system SP)
What I need to know, is how I change these connection properties to default to DMY - unfortunately, there doesn't seem to be any obious way of doing this.
Can anyone help me ?
I have reasoned that the solution lies with the default date settings in SQl Server (2000).
Using 'set dateformat', I set the format to DMY from MDY from my client. Using someone elses client however, I soon noticed that the setting for that client was still MDY. Further investigation told me that the connection properties actually override the server settings (including those set by the 'usp_set_start_options' system SP)
What I need to know, is how I change these connection properties to default to DMY - unfortunately, there doesn't seem to be any obious way of doing this.
Can anyone help me ?