Data returned irradically

  • Hi,

    i have a very strange behavior in a report. I have all the needed data in stored procedure. It runs and returns ok every time when I run it in management studio. When I run the report using this stored proc sometimes it returns data and oter times not at all. Using same parameters every time.

  • Have you run a profile or trace when running the report?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply