hi all,
i want to change the sa password from my C# code.
i'm using SQL server 2000, win XP, .NET 2003 and need to develop a
simple application that changes the sa password from the code and not
the enterprise manager
i'll be logged in as an sa.
thanx for ur help and timeIf you will be logged in as a sysadmin, easiest is probably
to just send the SQL statement in your code:
sp_password @.new = 'YourNewPassword', @.loginame = 'sa'
-Sue
On 10 Aug 2006 06:22:00 -0700, Eng.Rana@.gmail.com wrote:
>hi all,
>i want to change the sa password from my C# code.
>i'm using SQL server 2000, win XP, .NET 2003 and need to develop a
>simple application that changes the sa password from the code and not
>the enterprise manager
>i'll be logged in as an sa.
>
>thanx for ur help and time
No comments:
Post a Comment