rowguid列删除

来源：互联网发布：美工就业前景编辑：程序博客网时间：2024/06/06 17:18

复制失败或删除复制时，可能会造成一些遗留问题，这个是经常见到的，而且这样的情况还经常发生，复制的使用过程中还是存在诸多问题的，朋友们可以一起说出来，改天找个微软的工程师问问如何解决，反正现在我有很多的问题不能解决，可能大家的复制应用还是比较少，真正使用起来还是有些疑惑的。

–droprowguid indexes

select 'drop index ' + sysobjects.name + '.' + sysindexes.name from

sysindexes

inner join sysobjects

on sysindexes.id = sysobjects.id

where objectproperty(object_id(sysobjects.name),'IsMSShipped') = 0

and sysindexes.indid > 0 and sysindexes.indid < 255 and (sysindexes.status &

64)=0

and index_col(sysobjects.name, sysindexes.indid, 1) = 'rowguid'

order by sysindexes.indid

–remove rowguid default constraints

select 'alter table ' + b.name + ' drop constraint ' + a.name from

sysobjects a

inner join syscolumns on syscolumns.id = a.parent_obj

inner join sysobjects b on syscolumns.id = b.id

where syscolumns.name = 'rowguid'

and objectproperty(object_id(b.name),'IsMSShipped') = 0

and a.xtype = 'D'

–remove rowguid columns

select 'alter table ' + sysobjects.name + ' drop column rowguid 'from

syscolumns

inner join sysobjects on syscolumns.id = sysobjects.id

where syscolumns.name = 'rowguid'

and objectproperty(object_id(sysobjects.name),'IsMSShipped') = 0