sql complete - execution history

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
wilgin
Posts: 2
Joined: Mon 05 Oct 2020 12:54

sql complete - execution history

Post by wilgin » Tue 06 Oct 2020 12:23

Hi,
i use a lot of scripts in ssms in sqlcmd mode. some scripts use :connect to change connection to other server and sometimes the parameter -U (user) and -P (password) are required for this. since i enabled the execution history, the password is also save in history.
is it possible to mark such lines to exclude it from history?
thanks for your answers
wilfried

alexa

Re: sql complete - execution history

Post by alexa » Wed 07 Oct 2020 09:46

Would you like to be able to exclude the whole rows from the Execution History?

wilgin
Posts: 2
Joined: Mon 05 Oct 2020 12:54

Re: sql complete - execution history

Post by wilgin » Wed 07 Oct 2020 14:06

Yes, to make sure that no passwords are saved on the local hard drive.
Thank you
Wilfried

alexa

Re: sql complete - execution history

Post by alexa » Thu 08 Oct 2020 11:51

There is no such possibility. Though, you can add a suggestion on the UserVoice forum where other users can vote for it https://devart.uservoice.com/forums/87893-sql-complete

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.

Also, you may be interested in the Execution History settings available in the 'Options' window (select 'SQL Complete -> Options...' from the main menu).

Post Reply