Is there any easy regex search way to identify whether no INSERT or DELETE happens in particular table?
The insert statement could be INSERT INTO tablename or INSERT tablename. The space could be more between the words. The same could be applied for DELETE.
How to search tables in a database that are not undergo insert or delete operation in all SPs, UDFs,..?
Please do assist.