467,074 Members | 1,088 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,074 developers. It's quick & easy.

using sqlserver to manage state

I've got a .NET web application that currently uses session to
maintain state. I am just looking down the road and thinking of
scaleability and if I need to go to a web farm, then using "inproc"
for managing my session will no longer work. I've done some research
and read about how SQL Server can manage session, but I've found very
little in terms of how to actually do this. Basically what I've found
so far is that I run a script that comes with .NET (can't think of the
name right now :)) which sets up the tables and stored procs required
to manage the sessions. My question is once this is done, how is it
actually implemented? Are any code changes required (from the
"Session.Add" and "Session.Item" used with inproc session management)?

Thanks.
Nov 18 '05 #1
  • viewed: 917
Share:
1 Reply
Hi,

No code changes required. you just need to set sessionState mode
attribute to Sqlserver.

refer to : http://idunno.org/dotNet/sessionState.aspx.
Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: +972-(0)52-8888377
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Devonish | last post: by
1 post views Thread by quique | last post: by
6 posts views Thread by A | last post: by
4 posts views Thread by John Q. Smith | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.