Ray,

Check with the Seattle SQL Server Users group. (I'm sure there is one). If no one there is willing or able to help, consider virtual tutoring via some internet...

I'm not talking about the service stopping itself so much as...

More details are definitely needed on the whole "not working out" statement.

Given your statement about JOINS taking care of the recordset and not needing a WHERE clause makes me think...

The best way to monitor object useage is through a Profiler Trace. Server-side is more efficient that GUI version, but either works. Filter your trace to look only for the...

Google this phrase only:

SSIS A network-related or instance-specific error has occurred while establishing a connection to SQL Server

You'll come up with PLENTY of links.

Things you should look into off...

Server Properties, Advanced. Remote Login Timeout.

Hope that helps.

You might also want to check the Event logs when this happens to see if they'll tell you anything you don't know.

You might want to repost this in the Admininstrating General Discussion forum. The backup forum might not be haunted by the people who have the answers you want.

I can actually see that being useful and not growing to monsterous proportions if it's admined...

You are a cruel, cruel man, John Rowan....

@sigh.

CirquedeSQLeil (4/29/2010)

---

MS CRM is one such application that does this. It permits end users to create new organizations (it can also be scheduled to do it automatically) - which...

There is a difference between Disaster Recovery and Business Continuity. You need to define which your client wants to do.

Iron Mountain Records Management has very good white papers on both...

Please tell me what this application is...

haakon 29117 (4/29/2010)

---

1 - If we stop the sqlservice with the following command: net stop /y mssqlserver , would all the information in the log files be written to the...

dallas13 (4/29/2010)

---

I was able to see the improvements after this. It worked for me.

But every time after failover this value again gets set to 10 sec

so you need to change...

OKAY, THAT'S IT!!! ..... I wish I'd know...