SQL server replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL server replication

I removed replication
And try to recreate it .
It keep asking me about DTS package
Before i never sow that wizard.
Did replication removal not went correctly
Thank you
You might check to see if there are any DTS packages, and if so, you might want to delete them and see what happens. If this doesn’t work, you may want to consider uninstalling and reinstalling SQL Server, if that is practical. ——————
Brad M. McGehee
This isn’t the first post I’ve seen where DBAs remove replication and have problems. It’s really important to remove replication in a certain way. Search MSDN for the proper method. When I first removed replication, I started deleting subscriptions individually and deleting Agent jobs, etc. BIG mistake! Some SQL books walk you through the process of removing replication, too. Good luck! Here is an excerpt from MSDN to give you an example: "Deleting articles from publications that have subscriptions is not allowed. To delete an article, you must first delete all subscriptions to the publication."
T Kelley
Valid tip by Kelly, you should spare time to see BOL for replication topics which covers the required information. Satya SKJ