How can I change the login name and password?

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.
Syntax
sp_password [ [ @.old = ] 'old_password' , ]
{ [ @.new =] 'new_password' }
[ , [ @.loginame = ] 'login' ]
HTH, Jens Suessmeyer.
"Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
news:9BA17C7E-07B5-43DE-BADF-F15AA921DF52@.microsoft.com...
> 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.
|||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@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:9BA17C7E-07B5-43DE-BADF-F15AA921DF52@.microsoft.com...
>
>
|||master..sp_password 'myoldone','mynewone','theusername'
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0B925CDD-32D6-49A1-B132-75C56007289B@.microsoft.com...[vbcol=seagreen]
>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 Smeyer" wrote:
|||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@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:0B925CDD-32D6-49A1-B132-75C56007289B@.microsoft.com...
>
>
|||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@.discussions.microsoft.com> schrieb im Newsbeitrag
news:11D32945-2151-4EFE-9608-CCEA419BDE07@.microsoft.com...[vbcol=seagreen]
> 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 Smeyer" wrote:
|||Sorry but I don't know what BOL means. OSQL? I typed the command from a
command promt. I thought I was in the wrong folder so I did a search of the
entire drive for the command sp_password and couldn't find it.
Sorry to be such a pest. I really appreciate you sticking with me.
Marty
"Jens Sü?meyer" wrote:

> 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@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:11D32945-2151-4EFE-9608-CCEA419BDE07@.microsoft.com...
>
>
|||-BOL (Books Online) Help for SQL Server included in the installing package.
-OSQL Commandline Uitl to query the SQl Server.
Start --> Run --> Cmd --> Then the command i send to you. here you can
execute the sp_chanegpassword command.
Further information, just raise a hand, you are not bothering me :-)
HTH, Jens Suessmeyer.
"Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
news:7B1AAD94-C5A0-4782-8BA6-2B1F6DC95E5E@.microsoft.com...[vbcol=seagreen]
> Sorry but I don't know what BOL means. OSQL? I typed the command from a
> command promt. I thought I was in the wrong folder so I did a search of
> the
> entire drive for the command sp_password and couldn't find it.
> Sorry to be such a pest. I really appreciate you sticking with me.
> Marty
> "Jens Smeyer" wrote:
|||I'm afraid I'm still lost. What folder to I have to be in when I execute the
command line? I have tried the command line at a command promt and get the
message that it is an unreconizeable command. Am I dumber than I thought?
"Jens Sü?meyer" wrote:

> -BOL (Books Online) Help for SQL Server included in the installing package.
> -OSQL Commandline Uitl to query the SQl Server.
> Start --> Run --> Cmd --> Then the command i send to you. here you can
> execute the sp_chanegpassword command.
> Further information, just raise a hand, you are not bothering me :-)
> HTH, Jens Suessmeyer.
> "Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:7B1AAD94-C5A0-4782-8BA6-2B1F6DC95E5E@.microsoft.com...
>
>
|||By the way, I found the article and the syntax is exactly what you said it
was. But I still get the error
"Jens Sü?meyer" wrote:

> -BOL (Books Online) Help for SQL Server included in the installing package.
> -OSQL Commandline Uitl to query the SQl Server.
> Start --> Run --> Cmd --> Then the command i send to you. here you can
> execute the sp_chanegpassword command.
> Further information, just raise a hand, you are not bothering me :-)
> HTH, Jens Suessmeyer.
> "Marty" <Marty@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:7B1AAD94-C5A0-4782-8BA6-2B1F6DC95E5E@.microsoft.com...
>
>