Msreplication removal from SQL Server 2000 servers

Posted At : November 13, 2007 12:06 PM | Posted By : suge
Related Categories: Tech Stuff

Awhile ago I ran into a problem with a couple applications in which replication had been enabled on the Databases and it screwed some thing up. This is a good sure fir way to get rid of replication shit within MSSQL.

select 'alter table '+ object_name(parent_obj) +' drop constraint '+name+
char(13)+' go'
From sysobjects where name like '%msrepl%' and type ='D' and
object_name(parent_obj)
<>'MSreplication_subscriptions'
GO
select 'alter table '+object_name(ID) +' drop column msrepl_tran_version '+
char(13) +'GO' from syscolumns where name like 'msrepl_tran_version%' and
object_name(ID) not like 'conflict%'
GO

Comments (1) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 388 Views