<div>
Thanks, I have tested this :<br />
<br />
SET SQLCMDUSER=B00A<br />
SET SQLCMDPASSWORD=toto<br />
SET SQLCMDSERVER=SRVSERVER\TES<wbr />T<br />
SET SQLCMDDBNAME=dbname<br />
sqlcmd &nbsp;-Q &quot;select count(*) from ATEST&quot; -o d:\test.sql<br />
<br />
But, I have this error:<br />
Login failed for user 'B00A'.<br />
<br />
Thanks<br />
bibi
</div>


Thanks, I have tested this :

SET SQLCMDUSER=B00A
SET SQLCMDPASSWORD=toto
SET SQLCMDSERVER=SRVSERVER\TEST
SET SQLCMDDBNAME=dbname
sqlcmd  -Q "select count(*) from ATEST" -o d:\test.sql

But, I have this error:
Login failed for user 'B00A'.

Thanks
bibi

<div>
<div class="content wysiwyg-content">
How it is possible to avoid putting in light the password of one to use sql in a sqlcmd script?<br />
<br />
Thanks<br />
<br />
bibi
</div>
</div>


How it is possible to avoid putting in light the password of one to use sql in a sqlcmd script?

Thanks

bibi

Mask password in sqlcmd command

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.