Start a conversation

Remove DRS tables and triggers

Run following script to list all DRS tables currently installed.

SELECT so.name FROM sysindexes si JOIN sysobjects so on si.id=so.id WHERE so.type='U' AND si.indid in (0,1) AND so.name LIKE 'DRS%' ORDER BY so.name

Drop each one as needed with this script --  DROP TABLE XXXX 

Use attached script to delete any active triggers created by AutoGen (if disabling and Generate does not remove them).

 

delete_all_custom_trigger.sql

  1. 2 KB
  2. View
  3. Download
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Dave J

  2. Posted

Comments