Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Reset Password and Create Logins from PowerBuilder...

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-01-06 : 09:52:20
Sufyan writes "I am trying to execute sp_password from PowerBuilder to reset a user password... But I keep getting this Error

Error = 15002
Text = The procedure 'sp_password' cannot be executed within a transaction.

Do you know what am I doing wrong?

Thanks..."

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2003-01-06 : 10:13:32
Um ... you're trying to change a password inside a transaction, exactly as the error message says. What would happen if the transaction rolled back?

Jonathan
{0}
Go to Top of Page
   

- Advertisement -