Wednesday, March 21, 2012

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,
DJLook up sp_configure in Books Online and you will be well on your way to answering your question.|||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

No comments:

Post a Comment