http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Functions%2Fsp_configure 2026-05-24T21:19:36Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Functions/sp_configure&diff=6696&oldid=prev 2010-05-26T13:46:16Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://www.sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Functions/sp_configure&diff=6697&oldid=prev 2010-05-26T10:23:59Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== Changing SQL Server Configurations==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> SELECT name, value_in_use<br /> FROM sys.configurations<br /> WHERE name IN (&quot;max degree of parallelism&quot;)<br /> EXEC sp_configure &quot;max degree of parallelism&quot;, 1<br /> RECONFIGURE<br /> GO<br /> EXEC sp_configure &quot;max server memory&quot;, 250<br /> RECONFIGURE<br /> GO<br /> SELECT name, value_in_use<br /> FROM sys.configurations<br /> WHERE name IN (&quot;max degree of parallelism&quot;, &quot;max server memory (MB)&quot;)&lt;/source&gt;<br /> <br /> <br /> <br /> == EXEC sp_configure &quot;allow updates&quot;, 1==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 2&gt;<br /> 3&gt;<br /> 4&gt; EXEC sp_configure &quot;allow updates&quot;, 1<br /> 5&gt; GO<br /> Configuration option &quot;allow updates&quot; changed from 0 to 1. Run the RECONFIGURE statement to install.<br /> 1&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == Limiting Trigger Nesting==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 3&gt;<br /> 4&gt; USE master<br /> 5&gt; GO<br /> Changed database context to &quot;master&quot;.<br /> 1&gt; -- Disable nesting<br /> 2&gt; EXEC sp_configure &quot;nested triggers&quot;, 0<br /> 3&gt; RECONFIGURE WITH OVERRIDE<br /> 4&gt; GO<br /> Configuration option &quot;nested triggers&quot; changed from 1 to 0. Run the RECONFIGURE statement to install.<br /> 1&gt; -- Enable nesting<br /> 2&gt; EXEC sp_configure &quot;nested triggers&quot;, 1<br /> 3&gt; RECONFIGURE WITH OVERRIDE<br /> 4&gt; GO<br /> Configuration option &quot;nested triggers&quot; changed from 0 to 1. Run the RECONFIGURE statement to install.<br /> 1&gt;<br /> 2&gt;&lt;/source&gt;<br /> <br /> <br /> <br /> == sp_configure [configname[,configvalue]]==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> Running this procedure with no parameters provides you with the current configuration. <br /> <br /> sp_configure &quot;user connections&quot;,300 <br /> GO&lt;/source&gt;</div>

Admin