Session ID Size.

  • Thread starter Thread starter Gibson Smith
  • Start date Start date
G

Gibson Smith

If I am storing session ID in the database, what should be the size?
Currently I am using SQL Server 2000 and varchar as my data type.

Gibson
 
Looking at the InstallSQLState.sql file that you use to create the SQL
server, I found a table that looked like this:
CREATE TABLE tempdb..ASPStateTempSessions (
SessionId CHAR(32) NOT NULL PRIMARY KEY,
Created DATETIME NOT NULL DEFAULT GETUTCDATE(),
...
)

now, I have no idea if that's right, but you'd think it would be

Karl
 
Karl,
Thanks for your unique research.
Gibson


Karl said:
Looking at the InstallSQLState.sql file that you use to create the SQL
server, I found a table that looked like this:
CREATE TABLE tempdb..ASPStateTempSessions (
SessionId CHAR(32) NOT NULL PRIMARY KEY,
Created DATETIME NOT NULL DEFAULT GETUTCDATE(),
...
)

now, I have no idea if that's right, but you'd think it would be

Karl
Click to expand...
 
Back
Top