Hello All,
WHen i am trying to change the column size in sql server 200 below steps
1. Right click on the table ->Design i am getting alert message has"
Saving definition changes to tables with large amounts of data could take a consider amount of time. while changes are being saved, table data will not be accessible.".
2. i tried using Alter syntax :
ALTER TABLE PPAP_Approval ALTER column CLID varchar(13) I am getting below error mssg from SQL Server 2000 version. Line 2: Incorrect syntax near 'column'.
Please correct me what is syntax to alter column size in SQL Server 2000 version.