Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sqlserver connection problems Expand / Collapse
Author
Message
Posted Thursday, October 3, 2013 11:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:26 AM
Points: 381, Visits: 1,857
we had a problem yesterday with all jobs skipping their schedule on a server for a small time frame at regular intervals. No information in the windows logs or event logs. We had restart the server to fix it. I was not able to connect to the sql server thru ssms.

A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)

I am trying to find out what exactly the issue is?
Post #1501286
Posted Friday, October 4, 2013 4:33 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 11:13 AM
Points: 15,527, Visits: 27,909
There are multiple causes for this message. Without more information, it's really hard to suggest what it might be. Have you checked the error logs on the server to see if there are any indications there?

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1501515
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse