Home Forums SQL Server 7,2000 Security Query runs slow as Stored Procedure RE: Query runs slow as Stored Procedure

  • July 2, 2003 at 3:22 pm

    #463978

    Idea 1: add WITH RECOMPILE to the proc.

    Idea 2: turn the query into dynamic SQL using exec('...'), with the values of the parameters inserted into the query string.