SQL Server Performance Forum – Threads Archive
DBCC Not Supported
SQL 2000 sp3 – Enterprise Edition – v8.00.760DBCC SHRINKDB(‘database’) Server: Msg 7959, Level 16, State 1, Line 1
The DBCC statement is not supported in this release.
DBCC execution completed. If DBCC printed error messages, contact your system administrator. Has anyone found a solution to this problem. Seems pretty odd Thanks
is this happening for all the dbs or only for TempDB
I have came across this issue for TempDB. You can shirnk tempdb from this http://support.microsoft.com/default.aspx?scid=kb;en-us;307487 —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
Never happends to me.
Did you try DBCC CHECKDB on same database?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
DBCC SHRINKDB is not supported in SQL Server 2000. Use DBCC SHRINKDATABASE instead. This is what it says in BOL about DBCC SHRINKDB: "Removed; no longer supported or available. Remove all references of DBCC SHRINKDB and replace with references to DBCC SHRINKDATABASE. Consider shrinking databases automatically by using the AUTO_SHRINK option of ALTER DATABASE." Karl Grambow www.sqldbcontrol.com
Yeap, I miss that.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
.. MS should have specify the error message correctly than creating confusions with recent releases. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Ahhh, well spotted! That had me stumped <img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br /><br />Thanks Karl. <br /><br />Chappy<br />
]]>