Mssql server 2000 sp_configure

I would like to know if I do a sp_configure 'allow update',0 do I have to also do a reconfigure with override also.
Who is Participating?
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
You can specify either RECONFIGURE or RECONFIGURE WITH OVERRIDE to make that option configured for your server..

Excerpt from MSDN:

"Both RECONFIGURE and RECONFIGURE WITH OVERRIDE work with every configuration option. However, the basic RECONFIGURE statement rejects any option value that is outside a reasonable range or that may cause conflicts among options. For example, RECONFIGURE generates an error if the recovery interval value is larger than 60 minutes or if the affinity mask value overlaps with the affinity I/O mask value. RECONFIGURE WITH OVERRIDE, in contrast, accepts any option value with the correct data type and forces reconfiguration with the specified value."
RiteshShahConnect With a Mentor Commented:
yes, you have to.
All Courses

From novice to tech pro — start learning today.