Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
0
Reply
How to avoid dropping TempDB tables when server reboot?
Hariharan Krishnamoorthi
7 years ago
286
Reply
Hi all,
How to avoid automatically dropping TempDB session tables when server is rebooting.
We are maintaing session state in sql server, when sql server is restarting the below two tables are dropping. we need to create them again. Is there any solution for this to avoid for creating these tables again and again?
TempDB Session Tables are
1. dbo.ASPStateTempSessions
2. dbo.ASPStateTempApplications
thanks in advance.
Hari
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
Composite index Vs Covering Indexes
Handling DB Deadlocks