June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2005 – FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: “A severe error occurred on the current command”

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Index
In SQL Server 2005 while testing Indexes I had created a table with one non clustered index only. I did not create any clustered index on table. After that I ran SELECT statement, it gave me following error. I was very surprised when I looked at error. It says Msg…
Read More

SQL SERVER – Msg: 2593 : There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.

Pinal Dave
SQL
SQL Error Messages, SQL Server, SQL Server DBCC

There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.

This message is displayed when DBCC command is ran for any database. It is harmless and displayed for information purpose only. For each database DBCC commands displays number of rows and number of pages it is using. DBCC CHECKALLOC is exception for this messages.

Read More