|
Два вопроса по DBCC DBREINDEX
|
||
|---|---|---|
Участник
Откуда: Санкт-Петербург - New York City
Сообщения: 4 885 |
||
| 14.11.2002, 10:48:53 |
|
|
|
|
|
Два вопроса по DBCC DBREINDEX
|
|||
|---|---|---|---|
|
#18+
1. Microsoft SQL Server 2000 Administrator’s Companion / Marcilina S. (Frohock) Garcia, Jamie Reding, Edward Whalen, Steve Adrien DeLuca. Appendix C -- DBCC Commands "DBREINDEX Was used to reindex a table's indexes. This command is no longer supported in SQL Server 2000. With Microsoft SQL Server 2000, use the DROP EXISTING clause with the CREATE INDEX command to accomplish this task." Это опечатка? 2. Books Online for SQL Server 2000 (Updated): "Result Sets Whether or not any of the options (except NO_INFOMSGS) are specified (the table name must be specified), DBCC DBREINDEX returns this result set; this example uses the authors table of the pubs database (values will vary): Index (ID = 1) is being rebuilt. Index (ID = 2) is being rebuilt. DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC DBREINDEX returns this result set (message) if the NO_INFOMSGS option is specified: DBCC execution completed. If DBCC printed error messages, contact your system administrator." Почему-то как я не запускал ее, ничего, кроме "DBCC execution completed. If DBCC printed error messages, contact your system administrator" не выводит. В чем может быть дело? Спасибо! ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.11.2002, 10:48:53 |
|
||
|
Два вопроса по DBCC DBREINDEX
|
|||
|---|---|---|---|
|
#18+
Вот ещё нашёл в BOL: DBCC DBREINDEX - DBCC (Level 1): SQL Server 2000 Removed; no longer supported. Remove all references to either the SORTED_DATA or the SORTED_DATA_REORG clauses of DBCC DBREINDEX and replace with references to the DROP_EXISTING clause ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 14.11.2002, 15:30:24 |
|
||
|
|
start [/forum/topic.php?fid=46&msg=32068053&tid=1818809]: |
0ms |
get settings: |
8ms |
get forum list: |
13ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
53ms |
get topic data: |
7ms |
get forum data: |
2ms |
get page messages: |
43ms |
get tp. blocked users: |
1ms |
| others: | 248ms |
| total: | 379ms |
| 0 / 0 |
