Page 1 of 1

Alter Timestamp datatype.have any one experience this before

Posted: Wed Mar 08, 2006 3:07 am
by jatuphot
MS SQL SERVER 2000

Column Timestamp currently is Timestamp datatype. I want to change to binary.
database->Table Design allow me , But MS SQL not allow me. but i cant' do it in table design coz 4000 tables to change everyday.


ALTER TABLE [TESTTABLE] ALTER COLUMN [Timestamp] binary(8) not null

---------
Server: Msg 4928, Level 16, State 1, Line 1
Cannot alter column 'timestamp' because it is 'timestamp'.



the reason that why i have to change this everyday coz i do a schedule replication, and replication doesn't allow to insert timestamp datatype.

Thanks in advance.

Posted: Wed Mar 08, 2006 8:29 am
by AGISB
Timestamp is a reserved word for a timestamp and not for binary.