What does the job do?

If it calls an external service (for example a third party tool), it could be that this service fails to return the signal when finished (service...

Found the link to the presentation I mentioned in my previous post:

http://www.sqlbits.com/Sessions/Event7/oracle_for_sql_server_dbas

Perhaps it's not excactly what you are looking for, but I've seen a PPT from Gavin Payne. His last slide mentioned these references/reading materials:

Oracle 2-day DBA Guide (download)

Oracle – A...

Can you check if the application is the cause of these messages (if possible temporarily shut down the application/service)?

Assuming the application is the cause:

- Does the...

Is this on a dedicated SQL Server or on a combined Application/SQL server?

Look for some kind of polling mechanism (because you get the message frequently). This could be a (powershell-)script,...

select HName, USERname, max(EndDate) as max_enddate

from #Info

where Description = 'Client'

group by HName, USERname

And is there additional information in the SQL Error logs?

The message states the error could be originated from another computer. Perhaps an application server that keeps trying to connect... Can you find out this other computer? Perhaps the Event...

In SSMS you can create a Database Diagram. I don't know if this is as complete as a DBML file, but it can give you a start.

Open SSMS

Expand the Databases...

Sorry... misread the Original Post (so my post was not applicable)

In the sample the EmployeeID is the primary key in the Employee table. The DepartmentID is the primary key in the Department table. The primary key in the EmployeeDepartment table...

On some occasions I've encountered mail problems. Most of these times some errors were reported in the SQL Agent log.

The solution for this issue was to change from database-mail to...

:-D:-D:-D

Hilarious!!

Read this link http://social.msdn.microsoft.com/Forums/sqlserver/en-US/0a58d127-f532-44f1-8507-f9131228b5c1/connection-error-provider-shared-memory-provider-error-0-no-process-is-on-the-other-end-of?forum=sqldatabaseengine and check/try the different options mentioned here. Possible options are "check default database", "check protocol", "start SQL Agent" and many others....

Open SSMS and connect to the instance. Expand the "instancename" (which is default allready expanded), "security" and "logins"...