VRT (4/28/2009)
Please guide me yar. How to change the column size in query analyzer, not in SSMS?
You can't alter a column that is part of the primary key or that is referenced as a foreign key by another table. You have to drop the primary key and foreign key(s) before you can alter the column.
Jason Wolfkill