Post reply

SQL Server 2008 SSMS and Regional Settings

  • October 8, 2010 at 1:13 pm

    #241395

    I have scenario in which I can't seem to find much about. In a nutshell if I have a client who's regional setting are, let's say US and a remote server which houses the database has a different regional setting GB, would there be any issues with updating\inserting data from the client via SSMS? I understand the client will see the data using its regional settings, but I'm concerned about data modifications form the client to the server using SSMS. Thanks.

  • October 8, 2010 at 1:18 pm

    #1234483

    The only issue you _might_ run into is datetime format differences...the brits do things all bass ackwards. That can be resolved by using SET DATEFORMAT, if needed..but it might not be.

  • October 8, 2010 at 1:20 pm

    #1234484

    Thanks, my concern would be dates in particular.

  • October 8, 2010 at 1:22 pm

    #1234485

    Yeah..if it's an insert, and he's using the british method of YY-DD-MM (I think that's what they do) and both DD and MM are < 12..there's a chance it would misinterpret it. Use the SET DATEFORMAT command just to be safe.

  • October 8, 2010 at 1:36 pm

    #1234497

    Thanks for the clarification.

  • October 8, 2010 at 2:14 pm

    #1234520

    What about editing table data from the Studio Manager? Would there be any issues?

Viewing 6 posts - 1 through 6 (of 6 total)

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