转载：关于发布后对rowguid列的一些处理

--  drop rowguid 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

转载于:https://www.cnblogs.com/jerryhong/archive/2008/03/20/1114855.html