Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Session State in SQL Server

Author  Topic 

Amjath
Yak Posting Veteran

66 Posts

Posted - 2006-07-19 : 23:50:03
Hi to all,

I like to store session values in Sql Server. For that first of all i configure the Sql Server And then i create ASPSTATE Database. what i want is, i want to add 2 more columns to the table AspStateTempApplications, and AspStateTempSessions.
Can i do that. Can i change the Scheme of that table. then What are all the sp's i have to change.

With regards
Amajth

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-07-19 : 23:56:46
>> Can i change the Scheme of that table?
It's your database. You can do whatever you want.



Edit: Don't cross post your question on multiple forums!




CODO ERGO SUM
Go to Top of Page

MichaelP
Jedi Yak

2489 Posts

Posted - 2006-07-20 : 12:54:59
Ok, someone's gotta ask.

Why are you doing this?

Michael

<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>

Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights.
Go to Top of Page
   

- Advertisement -