Perform Qualify Object Name on a bulk set objects
wstyp
Posts: 2 New member
Is there is a way to take an existing set of sprocs or views and run a Qualify Object Names operation without having to open each file in SSMS?
I want to be able to apply best practices in bulk. I have approximately 40 databases to do this on and doing it manually is extremely time consuming.
I want to be able to apply best practices in bulk. I have approximately 40 databases to do this on and doing it manually is extremely time consuming.
Tagged:
Answers
Thanks for reaching out to us regarding this.
Unfortunately this isn't currently possible. Quality Object Names is used to qualify object names in the current open query window only.
I appreciate that this would be useful functionality for you and so it would be worth logging a feature request for this on our SQL Prompt User Voice page: https://redgate.uservoice.com/forums/94413-sql-prompt. This was our development team will have visibility of it, and other customers can vote for it.
Dan Jary | Redgate Software
Have you visited our Help Center?