SQR Errors Calling an MSSQL Stored Procedure from within a SQL script

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

Hello All,

I am new to the list, so please forgive me if I'm not following the correct
protocol.

I'm having problems with SQR on a Microsoft SQL Server 6.5 platform.  I
have an SQR that calls a text file which contains SQL statements altering
an existing table.  The script is generated by PeopleSoft's Alter Table
process.   The last action the text file performs is an MSSQL stored
procedure, "sp_rename", which renames the table.

However, the SQR fails because it does not recognize the call to an MSSQL
stored procedure.  The message I receive is "Cannot Execute SQL."

The same SQR calling a similar script generated by PeopleSoft on an Oracle
platform, works correctly.

Does anyone know how to alter the SQR so it recognizes the stored procedure
as an MSSQL procedure?

Thanks in advance for any assistance.

-Rich.