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



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: 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)
  • Cant get a directory to delete from command prompt
    ... I researched and found the MoveFileEx command, ... If you could give me the exact syntax based upon the ... >I needed to do a restore of system files due to a virus. ... >really a DOS mode or not, a true DOS mode option was not ...
    (microsoft.public.win2000.cmdprompt.admin)
  • Re: Shortcut for two programs.
    ... are interdependant on each other at the same time.? ... Yes, a simple batch file should work, but I don't know the exact syntax.. ... Here's a post I found on the Start command: ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Filter Members of specific distribution group
    ... who belong to specific distribution groups? ... (Using your exact syntax, copied and pasted to ... command line). ...
    (microsoft.public.win2000.active_directory)
  • Re: query analyzer table owner
    ... You can quickly create scripts by using this command: ... WHERE TABLE_SCHEMA = 'oldowner' ... HTH, jens Suessmeyer. ...
    (microsoft.public.sqlserver.tools)