Perform Qualify Object Name on a bulk set objects

wstypwstyp Posts: 2 New member
edited February 23, 2022 9:58PM in SQL Prompt
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.

Answers

  • Hi @wstyp

    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.
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.