SQL Session State in a database other than ASPState?

[Matt]

I have several applications running in a hosted environment and the
provider will not allow either a session state service or a session
state on the sql server.

Is there any way I can add the session state tables to my own database
and use that instead? I have tried to put the "initial catalog" in the
connect string, but .Net doesn't like that...

Matt...
(e-mail address removed)

 

[Luke Zhang [MSFT]]

"initial catalog" means the default database opened when you connect to a
database server. For example, when you connect to a SQL server with
"initial catalog=pubs" , you will only access the data in database pubs.
Anyway, this seems not help to the session problem. You may need to contact
your provider if they support the Session object in ASP.NET. If not, we
have little to do: From the Request object, we can get the client's IP, and
save some record with the speciall IP in the database.However, without
Session object, we can't determine when a client will disconnect, the
records may be kept in the database.

Luke

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

 

[Luke Zhang [MSFT]]

This is by design and can't be changed.

Luke

(This posting is provided "AS IS", with no warranties, and confers no
rights.)