Results 1 to 5 of 5

Thread: tempDB , consistent connection

  1. #1
    Join Date
    Sep 2005
    Posts
    2

    tempDB , consistent connection

    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

  2. #2
    Join Date
    Aug 2005
    Posts
    31
    I think you cannot, because tempdb is re-created every time when server re-starts.

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    You can set auto reconnect in your connection string, lot of apps work that way.

  4. #4
    Join Date
    Sep 2005
    Posts
    2
    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

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Auto reconnect doesn't depend on tempdb.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •