Re: How can I change the login name and password?

My first post was the common expression based on BOL Syntax.

Where do you fire the commadn to the SQL Server, from OSQL ?

Jens Suessmeyer.

"Marty" <Marty@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:11D32945-2151-4EFE-9608-CCEA419BDE07@xxxxxxxxxxxxxxxx
> sp_password still comes up as an invalid command. In your second example
> you
> omitted @old, etc. Please give me the exact syntax and command.
> Thanks again
>
> "Jens Süßmeyer" wrote:
>
>> master..sp_password 'myoldone','mynewone','theusername'
>>
>> HTH, Jens Suessmeyer.
>>
>> ---
>> http://www.sqlserver2005.de
>> ---
>> "Marty" <Marty@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
>> news:0B925CDD-32D6-49A1-B132-75C56007289B@xxxxxxxxxxxxxxxx
>> >I typed exactly what you wrote, except for the brackets, at a command
>> >prompt.
>> > I got the error message that sp_password is not a recognized command.
>> > Is
>> > there a particular folder I have to be in for this to work? If I want
>> > to
>> > leave the password blank do I just not enter nothing or do I use the
>> > word
>> > null.
>> > Thanks for your help
>> >
>> > "Jens Süßmeyer" wrote:
>> >
>> >> Syntax
>> >> sp_password [ [ @old = ] 'old_password' , ]
>> >> { [ @new =] 'new_password' }
>> >> [ , [ @loginame = ] 'login' ]
>> >>
>> >>
>> >>
>> >> HTH, Jens Suessmeyer.
>> >>
>> >> "Marty" <Marty@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
>> >> news:9BA17C7E-07B5-43DE-BADF-F15AA921DF52@xxxxxxxxxxxxxxxx
>> >> > How can I change the login name and password? Quite frankly, I would
>> >> > like
>> >> > the
>> >> > login name to be same as my WIndows login and no passwrod.
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages

  • Re: Cannot Install DB
    ... Thats got it..with the OSQL -E it worked fine thru cmd.. ... > So perhaps you are not connected to the MSDE rathjer than to a SQL Server. ... > this on the command line: ... >>> HTH, Jens Suessmeyer. ...
    (microsoft.public.sqlserver.msde)
  • Re: How can I change the login name and password?
    ... Sorry but I don't know what BOL means. ... command promt. ... > Where do you fire the commadn to the SQL Server, from OSQL? ... >>> HTH, Jens Suessmeyer. ...
    (microsoft.public.sqlserver.msde)
  • Re: How can I change the login name and password?
    ... -BOL Help for SQL Server included in the installing package. ... execute the sp_chanegpassword command. ... >> My first post was the common expression based on BOL Syntax. ... >> Where do you fire the commadn to the SQL Server, from OSQL? ...
    (microsoft.public.sqlserver.msde)
  • Re: How can I change the login name and password?
    ... > I got the error message that sp_password is not a recognized command. ... >> HTH, Jens Suessmeyer. ... >>> login name to be same as my WIndows login and no passwrod. ...
    (microsoft.public.sqlserver.msde)
  • Re: How can I change the login name and password?
    ... sp_password still comes up as an invalid command. ... etc. Please give me the exact syntax and command. ... >>> HTH, Jens Suessmeyer. ...
    (microsoft.public.sqlserver.msde)
Loading