asked on

What is causing this error message? "Database ID 11, page (1:10932), slot 0, link number 1028 is invalid"

I went to run a SQL script today that I have run for years and received this message.
Database ID 11, page (1:10932), slot 0, link number 1028 is invalid. Run DBCC CHECKTABLE.

I have run DBCC CHECKTABLE on the 5 tables involved in the script and none come back reporting any issues.
I also ran DBCC CHECKDB(database) and that returned nothing either.

Any other DBCC UTILITIES or parameters i can run to find the problem?

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rwheeler23

ASKER

SQL Profiler only shows me what I already know and that is the name of the stored procedure. How do I get SQL Profiler to show what is happening inside the stored procedure. Inside the sp is a cursor looping through a few thousand records. I need to see where exactly it crashes.

slightwv (䄆 Netminder)

I'm not a SQL Server person.

In Oracle, I normally set up output statements inside the procedure so I can track progress.

I found this on SQL Profiler:

https://www.mytecbits.com/microsoft/sql-server/debugging-queries-inside-stored-procedure-using-profiler

rwheeler23

ASKER

I found what is causing this and it is not what I thought. I am going to open a new question on this. I discovered there is a sql function in the query. If you run the query as a T-SQL command it runs fine but if you run it as part of a stored procedure you get this message.

rwheeler23

ASKER

Thanks for the tip

What is causing this error message? &quot;Database ID 11, page (1:10932), slot 0, link number 1028 is invalid&quot;

What is causing this error message? "Database ID 11, page (1:10932), slot 0, link number 1028 is invalid"