Posted by KonRi on 12/20/06 09:56

I don't know how to pass strange looking passwords to sqlcmd. In sql I use
'pass' and that works fine, but what to do with command line applications
like sqlcmd?
if password contains no " sumbol I can use "password"
but what if the password contains " . / - or spaces?
ex.
password = 'a-d ". a"'

sqlcmd -S myServer -U myUser -P a-d ". a" -d "myDb" -i
"C:\myProcedure.sql" -o "C:\temp\myOutput.out" --->whon't work..


How to pass strange looking passwords to sqlcmd?

• Next in forum: Re: SQL 2005, "build" scripts?
• Prev in forum: Problem with CCommand::Open when query str is too long.
• Thread view: Problem with passing password to sqlcmd

[Reply to this message]