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

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