我记得同步字段是 timestamp ,如果不是,将下面处理代码中的 timestamp 换成相应类型--删除表中的所有 timestamp 字段的代码declare tb cursor local for
select s='alter table ['+a.name+'] drop column ['+b.name+']'
from sysobjects a
join syscolumns b on a.id=b.id
join systypes c on b.xtype=c.xusertype
where c.name='timestamp'declare @s varchar(8000)
open tb
fetch next from tb into @s
while @@fetch_status=0
begin
exec(@s)
fetch next from tb into @s
end
close tb
deallocate tb
select s='alter table ['+a.name+'] drop column ['+b.name+']'
from sysobjects a
join syscolumns b on a.id=b.id
join systypes c on b.xtype=c.xusertype
where c.name='timestamp'declare @s varchar(8000)
open tb
fetch next from tb into @s
while @@fetch_status=0
begin
exec(@s)
fetch next from tb into @s
end
close tb
deallocate tb
我已尝试通过delete from syscolumns 或alter table drop colmun说不能删除..
还是newid()函数产生的值,但是服务器取消复制后,这个函数就没有用了,插入新记录的时候就会出错