sp_configure (RECONFIGURE)
- From: "Alex" <test!@xxxxxxxxxxx>
- Date: Wed, 16 May 2007 14:38:39 +0300
Hello
When I run (copied from BOL as an example of enabling AWE) the following
statement I got an error.It did changes but with error message. Should I use
WITH OVERRIDE?
Can someone explain on subject? Is it BOL incorrect?
sp_configure 'show advanced options',0
RECONFIGURE
GO
sp_configure 'remote login timeout', 21
RECONFIGURE
GO
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Configuration option 'show advanced options' changed from 0 to 0. Run the
RECONFIGURE statement to install.
Server: Msg 5808, Level 16, State 1, Line 2
Ad hoc updates to system catalogs not recommended. Use the RECONFIGURE WITH
OVERRIDE statement to force this configuration.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Configuration option 'remote login timeout (s)' changed from 20 to 20. Run
the RECONFIGURE statement to install.
Server: Msg 5808, Level 16, State 1, Line 2
Ad hoc updates to system catalogs not recommended. Use the RECONFIGURE WITH
OVERRIDE statement to force this configuration.
.
- Follow-Ups:
- Re: sp_configure (RECONFIGURE)
- From: Jasper Smith
- Re: sp_configure (RECONFIGURE)
- Prev by Date: Re: SQL DB without any stored procedures?!
- Next by Date: Re: sp_configure (RECONFIGURE)
- Previous by thread: Re: SQL DB without any stored procedures?!
- Next by thread: Re: sp_configure (RECONFIGURE)
- Index(es):
Relevant Pages
|
