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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s