MS SQL Script's status

[william_mda]

Hi,

I'm trying to use the MS SQL Script plugin to create a database. The script works fine, except for the status display.

During the database creation, part of the script contains the database password. As all the scripts are being display to the screen, the password are being display as well as part of the status.

Is there a way to prevent this from displaying? I've tried setting PROGRESSTEXT = "" and PROGRESSMODE = MARQUEE, didn't help.

Thanks!

William

[CandiceJones]

What's probably best is for you to show a custom progress dialog right before running your SQL script, one that hides or completely deletes the progress label!

[DevilSun]

I played with this some, and found that it only displays three lines. So, I used a single inline comment at the top of my script and then some new line breaks. The key is to remember it's SQL, so you need your comment characters. It's not optimal, but it's an easy route around the problem...

Code: Select all

-- Installing database...


/* do your work here including user creation with passwords and it won't be displayed */