Executing Stored Procedure in SQR 4.2.3 on platform MSSQL 6.5

[Richard Wagner <richard.j.wagner@AC.COM>]

Hello All,

I'm having problems executing a stored procedure on a Microsoft SQL Server
6.5 database.  The line that kills the SQR is:

execute sp_rename 'PS_1', 'PS_DUMMY_RECORD'

The first time I attempt to run the SQR containing the above command, I
receive the error message,

Error on line 166:
   (SQR 3913) Could not EXECUTE stored procedure.

When I attempt to run the stored procedure a second time, I receive the
message,

SQR: Program Aborting.
(SQR 5528) ODBC SQL dbxact: SQLTransact error 0 in cursor 0:
   [Microsoft][ODBC SQL Server Driver]Communication link failure

At this point the database freezes and I have to stop and restart the
database at the SQL Server level.

The documentation seems to indicate that I need an INTO argument.......

"If the stored procedure specified in stored_procedure_name contains a
SELECT query, the
EXECUTE command must specify an INTO argument in order to process the
values
from the query. If no INTO argument is specified then the values from the
query will be
ignored."

The problem is the sp_rename procedure contains multiple select statements.


Can anyone help me out with the correct use of the execute command?

Thank You.