I ran the following script in FlameRobin.  Database is on a virtual machine in the cloud. 

When I checked results after running the script, also checked them in FlameRobin, all the changes had taken place EXCEPT TBLTESTER.TESTERLOGIN.  It was still the old size.

The script ran without error.  What could cause this?

DROP  INDEX idx_SubscriberLogin_LoginPwd;
COMMIT;

DROP INDEX IDX_TESTER_LOGIN;
COMMIT;

DROP INDEX IDX_TESTER_PWD;
COMMIT

ALTER TABLE TBLTESTER ALTER TESTERLOGIN TYPE Varchar(80);
COMMIT;

ALTER TABLE TBLTESTER ALTER TESTERPWD TYPE Varchar(32);
COMMIT;

ALTER TABLE TBLSUBSCRIBERLOGIN ALTER SUBSCRIBERLOGIN TYPE VARCHAR(80);
COMMIT;

ALTER TABLE TBLSUBSCRIBERLOGIN ALTER SUBSCRIBERPWD TYPE VARCHAR(32);
COMMIT;

CREATE ASC INDEX idx_SubscriberLogin_LoginPwd ON tblSubscriberLogin (SubscriberLogin, SubscriberPwd);
COMMIT;

CREATE ASC INDEX idx_Tester_Pwd ON tblTester (TesterPwd);
COMMIT;

CREATE UNIQUE ASC INDEX idx_Tester_Login ON tblTester (TesterLogin);
COMMIT;

Dixon Epperson