{{theTime}}

Search This Blog

Total Pageviews

SqlServer Error: A transport-level error has occurred when sending the request to the server.

Error:

A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

How to fix it?

This error occurs when there is a stale/inactive connection and try to run sql query. Close the NewQuery window, verify the database connection and rerun the query in new window.

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...