Alter Timestamp datatype.have any one experience this before

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jatuphot
Forum Newbie
Posts: 1
Joined: Wed Mar 08, 2006 2:52 am

Alter Timestamp datatype.have any one experience this before

Post 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.
AGISB
Forum Contributor
Posts: 422
Joined: Fri Jul 09, 2004 1:23 am

Post by AGISB »

Timestamp is a reserved word for a timestamp and not for binary.
Post Reply