SEARCH RESULTS

SQL Server 6.5: Some useful undocumented DBCC commands Alexander Chigrik chigrik@mssqlcity.com Introduction Undocumented DBCC commands: DBCC ...

Useful Undocumented Informational SQL Server 2005 DBCC Commands DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logical consistency...

Useful Undocumented Informational SQL Server 2008 DBCC Commands DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logical consis...

Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands Alexander Chigrik chigrik@mssqlcity.com Introduction Undocumented DBCC commands: ...

Using DBCC commands to troubleshoot SQL Server problems Use the DBCC TRACEON command to turn on the particular trace flag, which can be used to resolve the SQL Server problems. For example, you ...

Tips for using SQL Server 2005 Database Console Commands (Part 2) Consider using SQL Server 2005 undocumented DBCC ACTIVECURSORS command to return the active cursor's parameters such as curso...

I'm not sure that you can, but you can try to issue DBCC Page (DBID,1,32589,0). You have to replace DBID with the database's ID and also to run DBCC traceon (3604) in order to view the results in ...

I had this happen on a SQL 7.0 server. Although my next step was to try and drop and re-create all the index's or just reindex the db. Before I did that though I upgraded to SQL 2000 and it disapp...

I've tried both without success. Here is the DBCC output: Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:32589). The PageId in the page header = ...

How do I know what index it is? Here is my output from DBCC: Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 0, index ID 0, page ID (1:32589). The PageId in the page he...

Hello, all. I'm still getting the following errors when running the DBCC command with the 'REPAIR_ALLOW_DATA_LOSS' option. I've run it a few times consecutively to see if it would fix my problem. ...

The (ID 299148111) is the Table's object_id so select object_name('299148111') will give you the name of the table. The index name is already in the message and so is the database name. From th...

>I'm not sure what the error is or how to go about fixing this. If it is >an index, how do I know what index it is to drop/re-create? Index id > 2 and Sänt av: bounce-sql2k-6393394@l...

Hello Every one Could any one throw some light on the result set that I receive when I carried out dbcc check db (in Query Analyser) on two databases What do you suggest should be the best cour...

SQL Server 2005 DBCC Optimization Tips (Part 2) Consider using DBCC CHECKCATALOG command instead of DBCC CHECKDB command if you need to check for catalog consistency within the specified da...

Tips for using SQL Server 2005 Database Console Commands (Part 3) Use the DBCC UPDATEUSAGE command to correct pages and row count inaccuracies in the catalog views. When these inaccuracie...

Useful Undocumented Miscellaneous SQL Server 2005 DBCC Commands DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logical consistency...

SQL Server 2005 DBCC Optimization Tips (Part 1) Consider using DBCC CHECKALLOC command instead of DBCC CHECKDB command if you need to check the consistency of disk space allocation structur...

Useful SQL Server 2005 trace flags by Alexander Chigrik Introduction Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You ca...

Useful Undocumented Maintenance SQL Server 2005 DBCC Commands DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logical consistency o...