Changing the password in SQL Server was much easier. You just type the following thing and password for the account is changed:
sp_password 'Old','New', Account
But this dont work for Sql Server 2005. Initially I thought whats worng with the SQL Server, but later I realized that it may be different for the two versions. At last I found it and here it is:
ALTER LOGIN Account_Name WITHPASSWORD = 'New_Password'OLD_PASSWORD = 'Old_Password';GO
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: