Re: Database Names

2012-07-23 Thread Walters, Mark
Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Benz, Michael Sent: 23 July 2012 01:54 To: arslist@ARSLIST.ORG Subject: Database Names ** Hello World Our remedy database is growing a lot faster then we'd like. So we ran a report that show us our largest tables

Re: Database Names

2012-07-23 Thread Goodall, Andrew C
, Michael Sent: Sunday, July 22, 2012 7:54 PM To: arslist@arslist.org Subject: Database Names ** Hello World Our remedy database is growing a lot faster then we'd like. So we ran a report that show us our largest tables. The bad side is, is that remedy did not name them very nicely at all

Database Names

2012-07-22 Thread Benz, Michael
Hello World Our remedy database is growing a lot faster then we'd like. So we ran a report that show us our largest tables. The bad side is, is that remedy did not name them very nicely at all! Is there any easy way so find out what table is what form? EG: dbo.B2109C100351 is 14 GIG and

Re: Database Names

2012-07-22 Thread Francois Seegers
Hi Michael, Here you go... select name, schemaid from arschema where schemaid = 'T2109' Regards Francois From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Benz, Michael Sent: Monday, July 23, 2012 2:54 AM To: arslist@ARSLIST.ORG Subject: Database

Re: Database Names

2012-07-22 Thread Jason
: Database Names ** Hello World   Our remedy database is growing a lot faster then we’d like. So we ran a report that show us our largest tables. The bad side is, is that remedy did not name them very nicely at all! Is there any easy way so find out what table is what form?   EG: dbo.B2109C100351

Re: Database Names

2012-07-22 Thread Francois Seegers
23, 2012 3:20 AM To: arslist@ARSLIST.ORG Subject: Re: Database Names ** Hi Michael, That's an attachment field on a form with the schema ID of 2109. You can run the following SQL statement to determine which form it is. select name from arschema where schemaId = '2109' T2109 holds record data

Changing field database names

2007-02-16 Thread Susan Palmer
Hi everyone, Yes, this is a simplistic question but I don't have my dev server to test it on right now because it's been upgraded. I generally don't do this but I have been requested to change about 20 fields. It's all right to have the field label and the field database name out of sync on a

Re: Changing field database names

2007-02-16 Thread Lammey, Peter A.
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Friday, February 16, 2007 11:45 AM To: arslist@ARSLIST.ORG Subject: Changing field database names ** Hi everyone, Yes, this is a simplistic question but I don't have my dev server to test it on right now

Re: Changing field database names

2007-02-16 Thread Shellman, David
:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Friday, February 16, 2007 11:45 AM To: arslist@ARSLIST.ORG Subject: Changing field database names ** Hi everyone, Yes, this is a simplistic question but I don't have my dev server to test it on right now because it's been upgraded. I generally

Re: Changing field database names

2007-02-16 Thread Thad Esser
Shellman, David [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/16/2007 08:54 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Changing field database names ** Susan, Yes you can change the database fieldname