Other Support Options
|
| • |
Listserv
Pose a question to other users. |
|
|
| Revised | : | January 5, 2006 (mc) |
| Version | : | Microsoft SQL Server 2000 and greater |
| Revision | : | 1 |
HOWTO: Changing the size of a field in the ILLData database
January 5, 2006
SUMMARY
Using the SQL Enterprise Manager tool in Microsoft SQL Server, you can increase the size of data fields in ILLiad up to 250 characters.
EXAMPLE
One field that many sites need to expand is the SSN field. Many sites use a longer number than a 9 digit ssn, so need to increase the size. This example shows how to increase the SSN size from 9 to 14.
- Open SQL Enterprise Manager
- Expand Microsoft SQL Servers, then SQL Server Group, then your ILLiad server
- Expand the Database folder, then the ILLData database
- Right click on the ILLData database and make a BACKUP. This is VERY important. Changing the field size in a table could result in loss of data if there is a problem on the server.
- Click on Tables. On the right-hand side, you will see a list of ILLiad tables. The SSN field is in the Users table for single sites and the UsersALL table for Shared Server sites.
- Right click on the table name and choose Design Table
- Scroll until you find the SSN field
- Under the Length column, change the 9 to a 14.
- Hit the save button (looks like a little floppy disk).
- Close the Enterprise Manager
MORE INFORMATION
You can not increase the field size to more than 250 characters. Also, be aware that increasing file sizes may change the default print documents appearances (since the data fields are now larger than the defaults).
