What is Stack Dump in SQL Server

Question

Hello Can someone please tell me what Stack dump or Stack dump error means in SQL Server why and how it occurs in SQL Server??

Jignesh Trivedi · Answer

hi Is there any error number? Please refer below link http://troubleshootingsql.com/tag/stack-dump/ hope this will help you.

Joginder Banger · Answer

This error and state indicates that you've got missing information in one of the system tables in a database (i.e. metadata corruption). In the SQL Server error log (buried down in the LOG directory) you should be able to see which database is giving the problem. After that you should be able to restore the database (sounds like you have backups). more information about this problem you can hit this link : http://www.sqlservercentral.com/Forums/Topic695886-266-1.aspx