On Fri, 2004-05-07 at 16:01, McMahon, Chris wrote:
> Hello... 
>       I've googled a lot, looked in the archives, and am finding not
> much:  is it possible to change the password of the "sa" user in a MSSQL
> database with DBI?  

$dbh->do("exec sp_password <oldpassword>, <newpassword>");

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
[EMAIL PROTECTED]                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html


Reply via email to