Re: Using DOS batch file to change MSDE blank passwords
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 11/25/03
- Next message: F_MIkey: "Re: Using DOS batch file to change MSDE blank passwords"
- Previous message: F_MIkey: "Using DOS batch file to change MSDE blank passwords"
- In reply to: F_MIkey: "Using DOS batch file to change MSDE blank passwords"
- Next in thread: F_MIkey: "Re: Using DOS batch file to change MSDE blank passwords"
- Reply: F_MIkey: "Re: Using DOS batch file to change MSDE blank passwords"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 25 Nov 2003 19:42:57 -0000
If you want osql to quit after it has run your commands, use the -Q switch
e.g
osql -Usa -P -Q"Exec sp_password NULL,'Test!01','sa'" -n
(the -n stops the anoying numbers)
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "F_MIkey" <anonymous@discussions.microsoft.com> wrote in message news:3F839990-5CD2-4CE8-AC28-7BEAF53EB99D@microsoft.com... Hello. I am attempting to write a batch file that will automatically logon and set the blank passwords on multiple users laptops to a password of IS Supports choosing. My scripting skills are very raw but here is what I have thus far: osql -U sa -P Exec sp_password NULL,'Test!01','sa' go exit All I am able to accomplish is the following: osql -U sa -P 1> I don't want the users to have to do ANYTHING. Can someone help me accomplish this?
- Next message: F_MIkey: "Re: Using DOS batch file to change MSDE blank passwords"
- Previous message: F_MIkey: "Using DOS batch file to change MSDE blank passwords"
- In reply to: F_MIkey: "Using DOS batch file to change MSDE blank passwords"
- Next in thread: F_MIkey: "Re: Using DOS batch file to change MSDE blank passwords"
- Reply: F_MIkey: "Re: Using DOS batch file to change MSDE blank passwords"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
