Great SQL Server Error

When attempting to:

ALTER TABLE MYTABLE ALTER COLUMN TIMESTAMP varbinary(8) NULL

The following error is raised:

Cannot alter column ‘TIMESTAMP’ because it is ‘timestamp’.

You have to do the following:

ALTER TABLE MYTABLE DROP COLUMN TIMESTAMP
ALTER TABLE MYTABLE ADD TIMESTAMP varbinary(8) NULL

Leave a comment