cool..thanks

That worked as far as accepting the altered proc...but when I go to run I get an error-

this is what...

We are having trouble with the syntax -

When I change it to what you suggested I get an error:

Msg 102, Level 15, State 1, Procedure spPaymentViewGetPagedByUserId, Line 79

Incorrect syntax near...

sure..

exec spPaymentViewGetPagedByUserId @PageIndex=0, @PageSize=25, @PaymentStatus='P, VR, AM'

USE [dbVBank]

GO

/****** Object: StoredProcedure [dbo].[spPaymentViewGetPagedByUserId] Script Date: 07/14/2011 10:55:23 ******/

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[spPaymentViewGetPagedByUserId]

@PageIndex int,

@PageSize int,

@PaymentStatus varchar(100),

@UserId varchar(25)...

yep I talked to the dev again and he said it was a dynamic parameter..so they have...

lutz - it is a table valued function

here's the function - -- ==========================================================================================

-- Author: Jeremy Truitt (as taken from Erland Sommarskog, SQL Server MVP. Located at:

-- http://www.sommarskog.se/arrays-in-sql-2000.html#iterative

--

-- Create...

it does run faster (3 sec) if I take out the last join

I talked to the dev and he says he must use that function -

check the cert on the server

true.. I was assuming all variables where the same..

also if the proc runs fine in ssms ..then it's prob not parameter sniffing

Is this correct? You are seeing this on everyproc?

Are you sure you want to do that?

Most of the time it's better to let SQL handle memory allocations.

You can do most if not all of what you need without buying anything..

but if you want a kewl GUI type program then you can check out -

Quest Software

Idera

please and thank you go a long ways..

No , in the GUI I click on the group then 'status' then I click 'deny' under permission to connect to database engine.

It shows 'deny' for the group...but when I...