alter column with date timestamp

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

alter column with date timestamp

Author

Topic

nord
Posting Yak Master

126 Posts

Posted - 2012-02-24 : 10:59:56

Hi,all
I need change column no null to null

ALTER TABLE dbo.attribute
ALTER COLUMN RowVersion timestamp null;
I have some error:
Msg 4927, Level 16, State 1, Line 1
Cannot alter column 'RowVersion' to be data type timestamp.
thanks for all

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-02-24 : 12:20:46

That's right, you can't. You could drop it and recreate it though.

http://msdn.microsoft.com/en-us/library/ms190273(v=sql.100).aspx

The modified column cannot be any one of the following:

A column with a timestamp data type.