"with recompile" SP option
In addition to my recent post Running SP with Access pass-through query. set nocount on did the trick, but only for one day. My next try was to add with recompile option to store procedure declaration, and after 2 weeks I must admit this was a solution!
CREATE PROCEDURE [dbo].[MySP] @FilterExpr varchar(100)
Labels: SQL Server