Kbase P23974: Cannot execute SQL Server system stored procedures within a
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/04/2003 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
Cannot call a MS SQL Server system stored procedures
Using the RUN STORED-PROC statement
Using the send-sql-statement option
37000: [Microsoft][ODBC SQL Server Driver][SQL Server]The procedure 'sp_password' cannot be executed within a transaction.
CAUSE:
The RUN SORED-PROC statement starts a transaction. However the MS SQL Server system stored procedures cannot be executed within a transaction.
FIX:
Use the -Dsrv AUTOCOMMIT,1 connection parameter.