Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
0
Reply
How to avoid dropping TempDB tables when server reboot?
Hariharan Krishnamoorthi
May 18 2017 5:12 AM
269
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
Composite index Vs Covering Indexes
Handling DB Deadlocks