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 lengthin 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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Gr8, bullseye ans. thank you
]]>