Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to remove SQL Server replication attributes from all replicated objects in a restored Systems Management Server 2003 site database
Article ID: 835860 - View products that this article applies to.
This article describes how to remove Microsoft SQL Server replication attributes from all replicated objects in a restored Microsoft Systems Management Server (SMS) 2003 site database.
You must remove SQL Server replication attributes before you do the following:
How to remove SQL Server replication attributes from all replicated objects in a restored SMS site databaseWe do not recommend that you, or any user, change system tables directly. For example, do not try to modify system tables by using DELETE, UPDATE, or INSERT statements or by using user-defined triggers.
To remove the SQL Server replication attributes, follow these steps.
Note The following procedure depends on SQL Server system tables. The structure of these tables may vary with different SQL Server versions.
For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/829828/ )Setup /testdbupgrade does not succeed on a restored site server database
(http://support.microsoft.com/kb/326352/ )You receive error 3724 when you drop a non-replicated object