Larry, To the best of my knowledge, commas are never ‘stored’ in an integer value however large it may be in a database. It would have been an illegal character if an attempt was made to save a comma to an integer column. It must be the way your database engine is reading the values when retrieving it from the database. You might want to check some of your global database settings and I won’t be surprised if there is something that has integer columns formatted that way when retrieving values from them..
Joe From: Larry Barnes Sent: Tuesday, February 22, 2011 12:41 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: SQL 2005 to 2008 question ** Sorry, I should have mentioned that we upgraded to sql 2008 from 2005 and remedy seems to find commas in integer values We have a test server that we brought up using a backup of the database from our production server. The production server is running SQL 2005 and the test server is running 2008. When I run Development Studio and save changes to any form, filter, etc. I get the following error and I'm wondering if anyone has seen this. Group having ID :-30,050 does not exist on the server. This group has been removed from the permission list., 5309, HRMS:EmployeeEntry-FindUserToMirror Thanks for your time, Larry B. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"