Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    8

    Unanswered: STORED PROC => OPENQUERY => Cannot Process Object

    Greetings,

    Creating a stored procedure which executs a SELECT statement against DB2 using ad-hoc OPENQUERY statement returns the following error:

    Msg 7357, Level 16, State 2, Procedure usp_bbbb_aaaa_xxxx, Line 21
    Cannot process the object "SELECT DISTINCT

    Looking for insight to understand the concept of how stored procedures are getting saved and causing this kind of error

    Thanks

  2. #2
    Join Date
    Feb 2005
    Posts
    10
    hi,

    can you post your openquery statements? - are you building your select query dynamically?

    cheers

    chappo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •