Printable View
In MSSQL2000 I want to know how to make a user have a constant connection even if the the Server restarts . Im aware that tempDB clears itself everytime the server restarts, but still wanna know if i can have users/applicaitons connected even though the server restarts
I think you cannot, because tempdb is re-created every time when server re-starts.
You can set auto reconnect in your connection string, lot of apps work that way.
Thanks , Alexander and rmiao for the response ... the thing is , the everytime the server restarts, i was wondering if i can have the users connected even though the tempDB is recreated on the server restart .. Im desperately looking out for solutions on this problem, thanks for your support
Auto reconnect doesn't depend on tempdb.