If the queue specified in the RECEIVE statement has the queue status set to OFF, the statement fails with a Transact-SQL error.

• 如果RECEIVE语句指定的队列的队列状态设置为OFF,则该语句将失败,并返回Transact-SQL错误。