Posted by Erland Sommarskog on 04/05/06 10:14

Shilpa (shilpa.nagavara@unisys.com) writes:
> I am getting the following error.
> A transport-level error has occurred when sending the request to the
> server. (provider: Shared Memory Provider, error: 0 - The system cannot
> open the file.)
>
> On performing the same operation again, it happens fine without any
> error.

That's just the way it works. If Mgmt Studio looses contact with SQL
Server, because the network goes down and up, or SQL Server is restarted,
you will get this message. Next time you try, SSMS reconnects automatically.
Query Analyzer handles this situation more gracefully, as it reconnects
directly when it detects that the connection is broken.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Transport Level Error has occured
• Prev in forum: Reversing string concatenation
• Thread view: Re: Transport Level Error has occured

[Reply to this message]