kuldip.bhatt (3/24/2009)
how i give the usrename and password in the sql command?:setvar Maindbserver "NHSserver"
:setvar Maindb "NHS_031209"
:Connect $(Maindbserver)
go
$ maindb
:connect $(Maindbserver) -U YourUserName -P YourPassword
Personally I would avoid SQL standard security for scripts like the plague. It would mean you have a clear text file with credentials exposed.