Alter Table- sql 6.0 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Alter Table- sql 6.0

Hi have two things need resolution 1)the output of SELECT LEN(program_name),program_name from master..sysprocesses in sql2000 i am gettin correctly with diff programs with different length
in sql 6.0 i can see every program name length is 30 . eg: SQl Perfmon has lenght 30 2)ALTER TABLE useractivity ALTER COLUMN [program_name] [varchar] (80) NOT NULL not workin in sql 6.00 . anyway one hav any idea hw to do tht in sql6.00 . Please tell me your experience abt it .

There is a huge difference in the architecture of SQL 6 and SQL 2000, whatever values executed are correct pertaining to that version. In version 6 there is no facility to ALTER COLUMN using ALTER TABLE, in order to achieve you must drop the table and recreate with new column names. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Gr8, bullseye ans. thank you