---
title: "GET_TRANSMISSION_STATUS (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "07/26/2017"
ms.prod: "sql-non-specified"
ms.reviewer: ""
ms.suite: ""
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "language-reference"
f1_keywords: 
  - "STATUS_TSQL"
  - "TRANSMISSION"
  - "TRANSMISSION_TSQL"
  - "GET_TRANSMISSION_STATUS"
  - "STATUS"
  - "GET_TRANSMISSION_STATUS_TSQL"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "conversations [Service Broker], transmission status"
  - "Service Broker errors, transmission status"
  - "transmission status information"
  - "status information [SQL Server], conversations"
  - "GET_TRANSMISSION_STATUS statement"
ms.assetid: 621805d5-49ed-4764-b3cb-2ae4a3bf797e
caps.latest.revision: 36
author: "BYHAM"
ms.author: "rickbyh"
manager: "jhubbard"
---
# GET_TRANSMISSION_STATUS (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx_md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

  Returns the status for the last transmission for one side of a conversation.  
  
 ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)  
  
## Syntax  
  
```  
  
GET_TRANSMISSION_STATUS ( conversation_handle )  
```  
  
## Arguments  
 *conversation_id*  
 Is the conversation handle for the conversation. This parameter is of type **uniqueidentifier**.  
  
## Return Types  
 **nchar**  
  
## Remarks  
 Returns a string describing the status of the last transmission attempt for the specified conversation. Returns an empty string if the last transmission attempt succeeded, if no transmission attempt has yet been made, or if the *conversation_handle* does not exist.  
  
 The information returned by this function is the same information displayed in the last_transmission_error column of the management view sys.transmission_queue. However, this function can be used to find the transmission status for conversations that do not currently have messages in the transmission queue.  
  
> [!NOTE]  
>  GET_TRANSMISSION_STATUS does not provide information for messages that do not have a conversation endpoint in the current instance. That is, no information is available for messages to be forwarded.  
  
## Examples  
 The following example reports the transmission status for the conversation with the conversation handle `58ef1d2d-c405-42eb-a762-23ff320bddf0`.  
  
```  
SELECT Status =  
    GET_TRANSMISSION_STATUS('58ef1d2d-c405-42eb-a762-23ff320bddf0') ;  
```  
  
 Here is a sample result set, edited for line length:  
  
 `Status`  
  
 `-------------------------------`  
  
 `The Service Broker protocol transport is disabled or not configured.`  
  
 In this case, [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] is not configured to allow [!INCLUDE[ssSB](../../includes/sssb-md.md)] to communicate over the network.  
  
## See Also  
 [sys.conversation_endpoints (Transact-SQL)](../../relational-databases/system-catalog-views/sys-conversation-endpoints-transact-sql.md)   
 [sys.transmission_queue (Transact-SQL)](../../relational-databases/system-catalog-views/sys-transmission-queue-transact-sql.md)