Post reply

Query mystery ??

  • November 25, 2003 at 2:44 pm

    #483626

    I think we got it.

    We threw With recompile in the proc and bamm, back to normal.

    Question:

    Why was QA acting differently?

    Why was is recompile needed?

    Thanks

  • November 25, 2003 at 10:54 pm

    #483652

    Check your ,OLE-DB Service ,ADO is accessing the SQL Server through a totally diffrent set of libs , You might have cahanged some important index in a table ,wich some times need a recompile ,see sp_recompile

    Regards john

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

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