Registered: Not Yet Location: Country: State: Certifications: Working on:
Total Posts: N/A
How do you remove system objects?
We've just removed replication from our SQL2000 server and want to remove
the conflict_* tables that were created by replication. How do we go about
doing this? We also want to remove the stored procedures created for
replication. Any help will be appreciated
Registered: Not Yet Location: Country: State: Certifications: Working on:
Total Posts: N/A
RE: How do you remove system objects?
There is a stored procedure named sp_removedbreplication which can be used
to remove all the replication information from a database. If you need to
cleanly remove the replication information, please try this stored
procedure to see if it helps:
Exec sp_removedbreplication 'your_db_name'
This posting is provided "AS IS" with no warranties, and confers no rights.
Forum Rules: Who Can Read The Forum? Any registered user or guest. Who Can Post New Topics? Any registered user. Who Can Post Replies? Any registered user. Changes: Messages can be edited by their author. Posts: HTML code is OFF. Smilies are ON. vB code is ON. [IMG] code is OFF.
How do you remove system objects?
11-19-02 04:24 PM
