Scrub passwords from Sql History history

Joelg

Hi

I'm looking for a convenient way to scrub historical passwords for instance for "Create User" statements.
They are kept in SQL History's query history, even if I remove the password before closing the file.

Note that I do not want to remove the script from history. Since I use it for reference. Is there a way- or must I remove the query completely?

Also, it would be awesome if there was a scrub all secrets from history function. Maybe It exists and I missed it?

Best
Joel

Dan_J

Hi @Joelg

Thanks for your question!

Unfortunately this functionality does not currently exist in SQL Prompt. I appreciate this would be useful to you and so encourage you to log a feature request on our SQL Prompt UserVoice page - https://redgate.uservoice.com/forums/94413-sql-prompt. That way our development team will have visibility of this and can consider it in future releases of the product.