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 |
|
tonasis
Starting Member
2 Posts |
 Posted - 2008-03-27 : 10:26:00
|
| Hi allI've got a problem with an American software vendor, who's asked me to check and adjust the regional settings within SQL Express 2005, installed on an XP SP2 pcI'm scanning meta data into this databaseIf I enter a date field with a UK date format, I get an error in the SQL logsIf I enter a date field with a US date format, everything is fineThe XP box is setup with all UK region settingsI've been told that my SQL install should automatically use the region settings from whatever OS that it's installed onI've checked everywhere within SQL, and it all looks to be setup with UK region settingsI suggested to the software vendor that the problem lies with their softwareCan anyone suggest if I've missed anything, or where I should be checking my region settings within SQL?Kind RegardsTonasis |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-03-27 : 10:34:38
|
| Use the profiler to see what is being sent to the database.runselect convert(datetime,'15/02/2008')and convert(datetime,'02/15/2008')on the database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
tonasis
Starting Member
2 Posts |
Posted - 2008-04-01 : 11:48:14
|
| Hi NRAm a bit of a SQL newbieHow do I access/use the profiler? |
|
|
|
|
|
|
Regoinal settings