|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server 2000: Intger data types are now formatted with comma separators in QAHello all,
This seems to be a recent development. It appears that Integer data types are formatted with comma/1000's separators. I don't think this was occurring before. Is this just a simple setting in QA or EM on my workstation or is this a setting on the server that may have inadvertently been set? -- Thanks for any help anyone can provide, Conan Kelly > This seems to be a recent development. separators. I don't think this was occurring before.> > It appears that Integer data types are formatted with comma/1000's > setting on the server that may have inadvertently been set?> Is this just a simple setting in QA or EM on my workstation or is this a > Formatting is always client side.-- Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com In Query Analyzer, check [Tools], [Options], [Connections].
Clear the [User Regional Settings...] checkbox. -- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous You can't help someone get up a hill without getting a little closer to the top yourself. - H. Norman Schwarzkopf "Martijn Tonies" <m.ton***@upscene.removethis.com> wrote in message news:umjYuvW8GHA.3280@TK2MSFTNGP02.phx.gbl... > >> This seems to be a recent development. >> >> It appears that Integer data types are formatted with comma/1000's > separators. I don't think this was occurring before. >> >> Is this just a simple setting in QA or EM on my workstation or is this a > setting on the server that may have inadvertently been set? >> > > Formatting is always client side. > > > -- > Martijn Tonies > Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle > & > MS SQL Server > Upscene Productions > http://www.upscene.com > My thoughts: > http://blog.upscene.com/martijn/ > Database development questions? Check the forum! > http://www.databasedevelopmentforum.com > > In Query Analyzer, check [Tools], [Options], [Connections].
Clear the [User Regional Settings...] checkbox. -- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous You can't help someone get up a hill without getting a little closer to the top yourself. - H. Norman Schwarzkopf "Martijn Tonies" <m.ton***@upscene.removethis.com> wrote in message news:umjYuvW8GHA.3280@TK2MSFTNGP02.phx.gbl... > >> This seems to be a recent development. >> >> It appears that Integer data types are formatted with comma/1000's > separators. I don't think this was occurring before. >> >> Is this just a simple setting in QA or EM on my workstation or is this a > setting on the server that may have inadvertently been set? >> > > Formatting is always client side. > > > -- > Martijn Tonies > Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle > & > MS SQL Server > Upscene Productions > http://www.upscene.com > My thoughts: > http://blog.upscene.com/martijn/ > Database development questions? Check the forum! > http://www.databasedevelopmentforum.com > >  |
|||||||||||||||||||||||
Other interesting topics