old sql database trows error on new enging code example

Example 1: GET AROUND MAXIMIN PREFIX FOR RPC OUT ON LINKED SERVER

DECLARE @name sysname,
        @sql  nvarchar(MAX)

SELECT @sql = 
   'DECLARE cur CURSOR STATIC LOCAL FOR
       SELECT TOP (5) CompanyName FROM dbo.Customers
       ORDER  BY CustomerID'

EXEC sp_executesql @sql

OPEN cur

Example 2: GET AROUND MAXIMIN PREFIX FOR RPC OUT ON LINKED SERVER

DECLARE cur CURSOR STATIC LOCAL FOR
   SELECT ...

Tags:

Misc Example

Related