dbo-sysdownloadlist-transact-sql.md

title	dbo.sysdownloadlist (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	dbo.sysdownloadlist sysdownloadlist_TSQL dbo.sysdownloadlist_TSQL sysdownloadlist
dev_langs	TSQL
helpviewer_keywords	sysdownloadlist system table
ms.assetid	71087a4c-e829-488e-aa7d-a9476e2b4779
author	stevestein
ms.author	sstein

dbo.sysdownloadlist (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Holds the queue of download instructions for all target servers.

Column name	Data type	Description
instance_id	int	Identity column that provides the natural insertion sequence of rows.
source_server	sysname	Name of the source server.
operation_code	tinyint	Operation code for the job: 1 = INS (INSERT) 2 = UPD (UPDATE) 3 = DEL (DELETE) 4 = START 5 = STOP
object_type	tinyint	Object type code.
object_id 1	uniqueidentifier	Object identification number.
target_server	sysname	Name of the target server.
error_message	nvarchar(1024)	Error message if the target server encounters an error when processing the particular row.
date_posted	datetime	Date and time the job was posted to the target server.
date_downloaded	datetime	Date and time job was last downloaded.
status	tinyint	Status of the job: 0 = Not yet downloaded 1 = Successfully downloaded
deleted_object_name	sysname	Name of deleted object.

¹ The object_id column can be a value of -1, which corresponds to a value of ALL if the operation_code column is a value of DELETE.