With SQL Server 2005, this is producing a syntax error-

ALTER TABLE mytable ALTER COLUMN mycolumn SET DEFAULT 'something';

Yet google finds references that claim that syntax is supported. What
is the correct syntax?

Clustered Index Not Working
Stored procedure to change not nulls to nulls
To write SPs, or not to write SPs, that is the question....
Default Values Question
Query help