Hi Sudha,

You can create different view for each user. While creating view specify the
session name for each user. If the data is not pretty much big, you can keep
that in ASP.Net session too.

--
Let me know if you need further help

Regards
Sreejumon[MVP]
DOTNET makes IT happen

"sudha" <sudha_s@lycos.com> wrote in message
news:0e5f01c344de$9d742950$a001280a@phx.gbl...
> Hi There
>
> Are there ways to avoid creating temporary tables when
> using Custom Pagination of a Data Grid control?
>
> We're experiancing some issues with custom pagination
> related to the fact that we're using a single user on the
> SQL Server for all SQL Server stored procedure
> transactions.
>
> Therefore the temporary table is owned by that single user
> and not end user session based.
>
> Thanks in advance
>
>