http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL_Tutorial%2FSystem_Functions%2Fsp_helpdb SQL Server/T-SQL Tutorial/System Functions/sp helpdb - История изменений 2026-05-25T00:26:25Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/System_Functions/sp_helpdb&diff=6794&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_helpdb&diff=6795&oldid=prev Admin: 1 версия 2010-05-26T10:24:09Z <p>1 версия</p> <p><b>Новая страница</b></p><div>== EXEC sp_helpdb==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 3&gt; EXEC sp_helpdb<br /> name db_size owner<br /> dbid created status<br /> <br /> compatibility_level<br /> -------------------------------------------------------------------------------------------------------------------------------- ------------- ---------------------------------------------------------<br /> ----------------------------------------------------------------------- ------ ----------- -------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> ------------------------------------------------------------------------------------------- -------------------<br /> ClubRoster 1.68 MB J\Administrator<br /> 5 Aug 17 2008 Status=SUSPECT, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, IsAutoClose, I<br /> sAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled<br /> 90<br /> master 4.75 MB sa<br /> 1 Apr 8 2003 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L<br /> atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics<br /> 90<br /> model 1.69 MB sa<br /> 3 Apr 8 2003 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L<br /> atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics<br /> 90<br /> msdb 4.94 MB sa<br /> 4 Oct 14 2005 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L<br /> atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled<br /> 90<br /> ProSSEAppsCh07 1.68 MB J\Administrator<br /> 6 Aug 17 2008 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L<br /> atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoClose, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled<br /> 90<br /> tempdb 2.50 MB sa<br /> 2 Aug 17 2008 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L<br /> atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics&lt;/source&gt;<br /> <br /> <br /> <br /> == EXEC sp_helpdb MyDatabase==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> 3&gt; CREATE DATABASE MyDatabase<br /> 4&gt; GO<br /> 1&gt; EXEC sp_helpdb MyDatabase<br /> 2&gt; GO<br /> name db_size owner<br /> dbid created status<br /> <br /> compatibility_level<br /> -------------------------------------------------------------------------------------------------------------------------------- ------------- ---------------------------------------------------------<br /> ----------------------------------------------------------------------- ------ ----------- -------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> ------------------------------------------------------------------------------------------- -------------------<br /> MyDatabase 1.68 MB J\Administrator<br /> 6 Aug 17 2008 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=SQL_L<br /> atin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoClose, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled<br /> 90<br /> name fileid filename<br /> fil<br /> egroup size maxsize growth usage<br /> -------------------------------------------------------------------------------------------------------------------------------- ------ ----------------------------------------------------------------<br /> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---<br /> ----------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ ------------------ ---------<br /> MyDatabase 1 c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Databas<br /> e_2.mdf PRI<br /> MARY 1216 KB Unlimited 1024 KB data only<br /> MyDatabase_log 2 c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Databas<br /> e_2_log.LDF NUL<br /> L 504 KB 2147483648 KB 10% log only<br /> 1&gt; DROP DATABASE MyDatabase<br /> 2&gt; GO&lt;/source&gt;</div> Admin