User Profile

Collapse

Profile Sidebar

Collapse
rover
rover
Last Activity: Feb 26 '07, 09:25 AM
Joined: Sep 11 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rover
    replied to return values and recordset in one stored procedure
    in SQL Server
    A little update.

    So it seems that the issue is not related to the return values and recordset.

    I have created a small test application which returns a recordset just fine.

    Could it be possible that SQL 2005 prevents information from sysobject to be exported (using SQL)?

    I have this in a stored procedure where I fetch a list of stored procedures where a user has rights:

    ...
    See more | Go to post

      Leave a comment:

    • rover
      started a topic return values and recordset in one stored procedure
      in SQL Server

      return values and recordset in one stored procedure

      Hi

      We have an application that runs fine on SQL 2000. Due to other applications we are forced to move to SQL 2005.

      One Stored Procedure isn't working on the new SQL 2005. It's a SP with output parameters and a recordset. It's working fine on SQL 2000.

      The data is returned through OLEDB to a VB6 application. In this application the output parameters are working fine (can access them). But the recordset...
      See more | Go to post
      No activity results to display
      Show More
      Working...