GrantMcc
SSC Rookie
Points: 25
More actions
May 15, 2003 at 8:51 am
#80226
I would like to change the sa password from the default (of blank) to a password of my choice but having problems. Can anybody assit with the correct syntax ?
Frank Kalis
SSC Guru
Points: 111183
May 15, 2003 at 8:55 am
#457294
Hi,
the following is taken from BOL (see sp_password)
sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
[ , [ @loginame = ] 'login' ]
HTH
Cheers,
Frank
-- Frank Kalis Microsoft SQL Server MVP Webmaster: http://www.insidesql.org/blogs My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply