I was thinking that the sp_configure command would do it on the fly, but it
won't.
Thanks
JOhn :}
At 01:26 PM 7/9/1998 -0700, you wrote:
>John Lange wrote:
>>
>> I thought there was a way to do this on the fly with an sql command, but
>> cannot remember how. Doing it in the config requires a reboot or sql
>> re-start, and I cannot take it down right now.
>
>You have to restart SQL Server no matter which way you change that
>setting.
>
>
>--
>Dale E. Reed Jr. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
>
John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers, Inc.
608.742.1601 & 6980 2800 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
Visit our online store @ http://www.microt.com/
Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html
--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)