I creating a SQL Secure.bat for my test server. because i try everything on that thing i need to reistall it allot.

So i want to create a batch file which secures it. but i m having a few problems.

I want to change the blank sa password on the sql.

but if i do this in the batch file
OSQL -U sa -Q "sp_password NULL, 'newpass', 'sa'"

then i get prompted for my original password which is blank so how do i give a blank password in a batch file.

And is there and environment variable for Program Files? Like there is for the windows dir (%systemroot%)

sp_password NULL, "yourpass", sa

i belive

Yeah but after that command is still get prompted for they original pass

hi DumpZ

this here should work with BLANk pass:
--------------------------------------------------------------------------
osql -Usa -P -Q"Exec sp_password NULL,'NEWPASS','sa'" -n
--------------------------------------------------------------------------


paste it in a batch file, and execute it in the mssql folder where the osql is.

Thanks man i'll try that!

On my system the path variable holds c:/program files.
meaning anything can be executed right from the command line, but the is no special windows variable to go to that dir that i know of.


The thing is, the reason the is a %systemroot% var is that you have c:/windows and c:/winnt.

program files is always the same, so it's useless anyways.

True, but if the system is in another language, like in german it is programme instead of program files

C:\Dokumente und Einstellungen\Administrator>echo %programfiles%
C:\Programme

Just type set in the command prompt to see all environment variables and their values.

type "SET" and you'll see all the enviormental variables... yes, the program files is %ProgramFiles% and it goes to C:\Program Files (unless you change the default...)

also, if you want to see just variables in one certain letter...
set a
(where a is, whatever letter you want)

also to be helpfull on it...
here's some they don't show
%time% = whatever time it is now, how to make batch files do something at a specific time
%date% = i think you can figure it out.
%random% = generates random numbers

Thanks you all this is all very helpfull.

I there also a possibility to delete the batch file after it is completed. because when i add del sql.bat at the end of the batch file it will not work. i tried calling another batch file but that didn't workt either

Try "del %0", works for me.

u can define additional "systemroot" dirs, to execute progs and batches directly.
just go in sys-manegament, advanced and then click environment variables.
then edit the PATH box and set your own systemroot dir.

Thanx loads tweakz20 I was looking for info on that to see what environment variables set

Can someone help me figure out how to make this bat file

I have ips in a txt file ip.txt
like

127.0.0.1
127.0.0.2

When i run the batch , I want to make the output such that it creates a new txt file/modifies the same ip.txt and adds a string at the beginning of each ip ,like

Hello 127.0.0.1
Hello 127.0.0.2

I"ve tried using echo but , it just starts it off in a newline.

Nee suggestions ?

Thx

FOR /F %i IN (ip.txt) DO echo Hello %i>ip2.txt
copy /Y ip2.txt ip.txt

To put this in a batch, use %% instead of %.

Thanks Blasta

About changing the SQL Password, its explained here:

http://security.uchicago.edu/windows/mssql/index.shtml