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.
Alter Timestamp datatype.have any one experience this before
Moderator: General Moderators