http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Functions%2Fsp_dboption
SQL Server/T-SQL Tutorial/System Functions/sp dboption - История изменений
2026-05-25T01:22:26Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Functions/sp_dboption&diff=6758&oldid=prev
в 13:46, 26 мая 2010
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_dboption&diff=6759&oldid=prev
Admin: 1 версия
2010-05-26T10:24:04Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== ANSI null default==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
When set to True, SQL Server follows the SQL 92 rules to see if a column can allow NULL values.<br />
<br />
EXEC sp_dboption "YourDatabaseName", "ANSI null default", "False"<br />
GO</source><br />
<br />
<br />
<br />
== autoclose - ensures that the database is cleaned up.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
EXEC sp_dboption "YourDatabaseName", "autoclose", "True"<br />
GO</source><br />
<br />
<br />
<br />
== autoshrink - A setting of True indicates that that this database can be shrunk in size safely.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
EXEC sp_dboption "YourDatabaseName", "autoshrink", "False"<br />
GO</source><br />
<br />
<br />
<br />
== dbo use - If set to True means that only the user ID that created the database has access and can use the database.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
EXEC sp_dboption "YourDatabaseName", "dbo use", "False"<br />
GO</source><br />
<br />
<br />
<br />
== quoted identifier==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
By setting this to OFF, you can delimit a string by either a single quote or a double quote. <br />
when set to ON, you cannot use double quotes around string variables as double quotes will be signifying a SQL Server identifier.<br />
<br />
EXEC sp_dboption "YourDatabaseName", "quoted identifier", "True"<br />
GO</source><br />
<br />
<br />
<br />
== read only - If set to True, no modifications to the data can be made.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
EXEC sp_dboption "YourDatabaseName", "read only", "False"<br />
GO</source><br />
<br />
<br />
<br />
== single - When set to True, only one user has access to the database at a time.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
EXEC sp_dboption "YourDatabaseName", "single", "False"<br />
GO</source><br />
<br />
<br />
<br />
== sp_dboption [databasename,option,{TRUE�FALSE}]==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
sp_dboption sales,"offline",FALSE</source><br />
<br />
<br />
<br />
== sp_dboption is a system function that allows a specific database option to be set.==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
EXEC sp_dboption "YourDatabaseName", "autoclose", "True"<br />
GO</source></div>
Admin