Post reply

SP_PrepExec results in a Constant Scan

  • October 26, 2006 at 4:58 am

    #668128

    try  http://support.microsoft.com/Default.aspx?id=224587

    I think it would have to use a constant scan to recover parameters passed in the statements. I'd suggest you use profiler to capture the query plan, rather than QA, although the detail is overwhelming you may find it more useful. I generally use QA to produce plans but if I'm really trying to find something I always use profiler. Make sure you include the binary data column in profiler.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing post 1 (of 2 total)

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