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

sys.transmission_queue Problem Expand / Collapse
Author
Message
Posted Thursday, December 18, 2008 2:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 18, 2008 6:59 PM
Points: 7, Visits: 15
While executing following query...
"select transmission_status from sys.transmission_queue;"

Either it is executing for aal the time and not completed or showing following 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.)"

Not able to figure out the problem. plz help

Thanks,
Nishant
Post #622468
Posted Thursday, December 18, 2008 3:04 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 10:30 PM
Points: 1,688, Visits: 8,759
I think you are running this statement in 2005 as this is 2000 forum. Also, is sql server instance started against which you are executing this query?

MJ
Post #622489
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse