Solved

error in error log

Posted on 2012-04-02
2
339 Views
Last Modified: 2012-06-27
hi

I am getting a lot of these errors in the event log of my server, how can i trap what is causing them?

A user request from the session with SPID 56 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

cheers
0
Comment
Question by:ac_davis2002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 15

Accepted Solution

by:
Anuj earned 500 total points
ID: 37795680
Check windows eventlog and SQL Server event log for more details about this error, also if you are experiencing this frequently try running SQL Server profiler trace to capture the SQL Statements, this will help.
0
 

Author Closing Comment

by:ac_davis2002
ID: 37800172
ACE!
0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question