Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    Toronto
    Posts
    26

    Unanswered: 'Remote Timeout Option' setting

    Hey All,

    Very simple one...how do I simply change the default from 20 seconds to 60 in the sp_config table...
    Thanks,
    DJ

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Look up sp_configure in Books Online and you will be well on your way to answering your question.

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Oct 2003
    Location
    Toronto
    Posts
    26
    The bible? Read it. i'll go back and look. Is it as easy as this?

    sp_configure 'show advanced options', 1;
    GO
    RECONFIGURE;
    GO
    sp_configure 'remote login timeout', 60;
    GO
    RECONFIGURE;
    GO

Posting Permissions

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