How to implement Sql server session mode with out own tables created(not generating temp tables using any commands)

Question

0.00/5 (No votes)

See more:

Can anyone tell me how to use sqlserver session mode without creating any predifined stored procedures and tables.
Can any one explain how to use this mode by creating our own tables

Posted 15-Dec-12 1:56am

waj1206

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RajeshwarReddy@.Net · Answer 1 · 2012-12-15T19:11:00

Solution 1

Hi,
If i'm correct you want to store the sessions in Sql server without creating any tables.

Here is a sample configuration block that you can add in web.config

XML

<sessionstate>
    mode="SQLServer"
    allowCustomSqlDatabase="true"
    sqlConnectionString="Data Source=.;Initial Catalog=SessionStateDB;"
    cookieless="false"
    timeout="20"
</sessionstate>

Also for furhter information plz refer this articel

http://support.microsoft.com/kb/317604[^]

Posted 15-Dec-12 19:11pm

RajeshwarReddy@.Net

Updated 15-Dec-12 19:22pm

v2

Comments

waj1206 17-Dec-12 10:12am

Thats not my question......
I have only sql express edition installed in my system.Hence i am not able to create preddefined tables and SP's required for sql server session mode.This is my main problem.
Is there any way we can create own own tables and store the sessions in that tables etc.

Wendelius · Answer 2 · 2012-12-17T09:04:00

Based on your latest comment, there's some kind of misunderstanding. SQL Server Express Edition does not have a limitation that would prevent you from creating tables, stored procedures, views, triggers etc beforehand. Express Edition works just like other editions what comes to this aspect. The limitations of Express Edition are mainly related to database size, memory or CPU usage and advanced capabilities.

One thing that could cause confusion is that if you have attached the database to your project, every time you run the application the database in your project may replace the changed database in bin folder. In such case it would look like all modifications are lost.

If that is the case, then one way to tackle the problem is to run Express Edition as normal server (as a background service) and connect to it from the application instead of using user instances.