dotnet distributed apps: hey all,
i just configured my sql server to be the session state for my web page for
the first time (under fw v.1.1 ).

is there any maintenance involved when using sql server as session state?
for instance, do i have to clear tables every now and then?

thanks,

Havent used it in any commercial project but i think it would be a good idea
to presiodically re-create the index using DBCC
Syntax:
dbcc dbreindex('Table','IndexName | Leave wmpty if you wana recreate all
index associated with the table>',Fill Factor | make it 0 if you dont wana
change the fill factor);

You can also define a mainteance plan for it as well using Mainteance wizard
--
Mohammad Furqan Baqai
MCAD


[quoted text, click to view]