Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Deleting old replication (system) tables
- Thread starter rushdib
- Start date
Yes you can, its just not much fun. Only way i know of. And there may be others, but this is all i know. First you need to allow adhoc updates to the system tables. its a property in the server settings. Then you go to sysobjects table in the database those tables are in. Change the xtype of those tables from S to U. This changes them to user tables which you can then delete. Change back adhoc updates to not allowed.
Make sure you make a backup before you start... Hopefully soemone knows a differnt way since digging through system tables is not much fun. I think this is how i did it, but im not able to remember for sure. Best i can say is try it and see if it works. Im pretty sure it worked for stored procedures.
Make sure you make a backup before you start... Hopefully soemone knows a differnt way since digging through system tables is not much fun. I think this is how i did it, but im not able to remember for sure. Best i can say is try it and see if it works. Im pretty sure it worked for stored procedures.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question