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
Devart Team
Posts: 2909
Joined: Fri 24 Jun 2011 14:17

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
Devart Team
Posts: 2909
Joined: Fri 24 Jun 2011 14:17

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