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