You should never modify the tables directly.   What error are you receiving? 
(and if you turn on SQL Logs on the server you will see the actual SQL that is 
being executed)

As for the t vs T ... SQL Server is not case sensitive so that should not 
matter.

Fred

-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:[email protected]] On Behalf Of Hugo Ruesga
Sent: Tuesday, May 07, 2013 8:58 PM
To: [email protected]
Subject: [URGENT]Use Alter Table Alter Column on Remedy ARS
Importance: High

** 
Guys,

Besides that this could be a really silly question. I'd like to check with all 
of the gurus here.

I need to increase the length of the RLS field on Remedy (ARS 7.0.01 patch 007) 
over a custom development, but when I do this on the Admin, It returns an SQL 
error, and field is not saved on the form.

I went further and find that this table on the properties for the ARSystem DB 
(SQL Server) the table is labeled as t instead of T, what makes me think that 
someone had already played with the form. Question here is: Will I broke more 
at DB if I modify this field by using alter table and alter column commands?

Thanks
Hugo Ruesga 
Software Development Advisor
USĀ  972.577.7000 x 332.3868
MX +52 (33) 3332.3868

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Reply via email to