Layton ServiceDesk - Workflows - Change Length of User-Defined Field
From Layton Support
Contents |
Overview
In the interests of data integrity, there is no way to do modify the character length of a user-defined field in Layton ServiceDesk. It can be changed using Management Studio. This is a workaround that you should be careful to follow, as it involves temporarily disabling a safety feature.
Procedure
- Take Layton ServiceDesk Offline, to Prevent Users Using it:
- On the Layton ServiceDesk server, launch the Windows Services Console.
- Click World Wide Web Publishing Service.
- Click Stop the service to stop the service.
- Launch Management Studio and connect to your database.
- Back up your database.
- Disable Safety Feature:
- From the Tools menu, select Options. The Options dialog will open.
- In the left-hand column, click Designers.
- Uncheck the option Prevent saving changes that require table re-creation.
- Click the OK button to close the dialog.
- Database Modification:
- In the left-hand column, expand SERVER > Databases > Layton ServiceDesk > Tables.
- Right-click the dbo.request table and select Design.
- Click the usr_NAME column to be modified. User-defined columns begin with the string usr_. Do not modify a system (sys_) column, as this will break on future updates!
- In the Column Properties pane, change the Length to the desired number of characters. This only applies to text columns.
- Click the Close button for the table. You will get a confirmation dialog. Click the Yes button.
- A Save dialog will open, warning that a number of tables will be saved. These tables are related to the request table, and thus need to be modified. Click the Yes button. The table will close.
- Verification:
- If you would like to verify the change, expand dbo.request > Columns. Find the usr_NAME column. The length will be expressed as (nvarchar(LENGTH).
- Re-Enable Safety Feature:
- From the Tools menu, select Options. The Options dialog will open.
- In the left-hand column, click Designers.
- Check the option Prevent saving changes that require table re-creation.
- Click the OK button to close the dialog.
- Get Layton ServiceDesk Back Online:
- On the Layton ServiceDesk server, launch the Windows Services Console.
- Click World Wide Web Publishing Service.
- Click Start the service to start the service.