Hi steve!

I tried. It works.

I think that sql server generates something like this:

declare @author_id varchar(10)

declare @FindExact bit

exec spGetAuthorsList @author_id, @FindExact

when you execute:

Execute sp_executesql N'exec spGetAuthorsList @author_id, @FindExact' , N'@author_id varchar(10), @FindExact...

try the following:

Execute sp_executesql N'exec spGetAuthorsList @author_id, @FindExact' , N'@author_id varchar(10), @FindExact bit' ,  @author_id = '1' ,  @FindExact = 0

In your original statement you are passing the variable...

I had the same problem with sql server 2000.

I solved it with SET NOCOUNT ON.

If NOCOUNT is OFF, every time sql server executes a statement it returns the number...