1. 

   apao, Member

   Hello everyone,

   when a report is deleted and the related stored procedure is not used by any other report, would it be possible for MyDBR to ask the user if he wants the stored procedure to be deleted?

   Best regards.
2. 

   myDBR Team, Key Master

   There is no bullet proof way of determining if a procedure is used or not. myDBR preserves the reports so that they are not accidentally deleted. This is the reason the report is not deleted when removed from myDBR report structure.

   --
   myDBR Team
3. 

   apao, Member

   I did not know reports were preserved even if you deleted them.
   The problem is that it can get pretty messy in the database when you see stored procedures that are no longer useful.
4. 

   myDBR Team, Key Master

   You can just drop the procedures you do no longer need. If the procedures start with sp_DBR (=are intended myDBR reports), you see the list of unassigned procedures when you click the 'New report' link.

   --
   myDBR Team
5. 

   apao, Member

   Ok, thanks for the tip!

Reply

You must log in to post.