Invalid object view - script selected objects as Drop
Would be useful to be able to choose a selection of Invalid objects and generate a Drop script for them all.
Rick
shared this idea
Thank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
Adam P
commented
Oops, I guess I can't edit my last post... first example is for dropping procs, second is for dropping views... but after I run those replacements I have to load them into something like Excel to de-dupe them
-
Adam P
commented
Please please please. Right now I'm selecting the results and pasting it into a text editor, running a regex against a bunch of rows like:
MyDB Stored Procedure dbo.HL7_PersonMedicalProcedureStageProcessor Invalid column name 'CreatedByClientAppCode'.
In notepad++ I use this for procs:
Search Mode: Regular Expression
Search: \w+\s+Stored Procedure\s+([\w\.\-]+)\s+.*
Replace with: drop procedure \1Search: \w+\s+View\s+([\w\.\-]+)\s+.*
Replace with: drop view \1