MSDE Password

I'm trying to apply a password to the (sa) account. When
I go to the dos prompt I type
osql -U sa
password:
1>sp_password @.old = null
2>@.new = 'password'
3>@.loginame = 'sa'
4>go
Then I get this error message
Msg 170, Level 15, State 1, Server _____, Line 2
Line 2: Incorrect syntax near '@.new'
what am i doing wrong
Try commas in between parameters like so:
1>sp_password @.old = null,
2>@.new = 'password',
3>@.loginame = 'sa',
4>go,
Bob
SuccessWare Software
"mcarter297" <anonymous@.discussions.microsoft.com> wrote in message
news:1d48001c453bc$190dfa40$a101280a@.phx.gbl...
> I'm trying to apply a password to the (sa) account. When
> I go to the dos prompt I type
> osql -U sa
> password:
> 1>sp_password @.old = null
> 2>@.new = 'password'
> 3>@.loginame = 'sa'
> 4>go
> Then I get this error message
> Msg 170, Level 15, State 1, Server _____, Line 2
> Line 2: Incorrect syntax near '@.new'
> what am i doing wrong
|||Hi,
OSQL -Usa -Ppasword -S Servername (Enter Key)
1>sp_password null,'newpassword',sa (Enter key)
2>go (Enter Key)
Thanks
Hari
MCDBA
"mcarter297" <anonymous@.discussions.microsoft.com> wrote in message
news:1d48001c453bc$190dfa40$a101280a@.phx.gbl...
> I'm trying to apply a password to the (sa) account. When
> I go to the dos prompt I type
> osql -U sa
> password:
> 1>sp_password @.old = null
> 2>@.new = 'password'
> 3>@.loginame = 'sa'
> 4>go
> Then I get this error message
> Msg 170, Level 15, State 1, Server _____, Line 2
> Line 2: Incorrect syntax near '@.new'
> what am i doing wrong