RE: An Introduction to the Service Broker Part 2

masri999

Old Hand

Points: 350

August 30, 2005 at 11:58 pm

#586355

Srinivas Sampath,

Thank you . Please see the info below

SELECT * FROM sys.transmission_queue

The session keys

for this conversation could not be created or accessed. The database master key is required for this operation.

46B90A7F-3919-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:36:10.670 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

46B90A7F-3919-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:37:01.823 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

C8E479AD-3919-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:37:28.510 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

C8E479AD-3919-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:41:14.957 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

3E0C3247-3A19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:41:46.410 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

3E0C3247-3A19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:50:55.230 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

E4ED3DA9-3B19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:51:40.400 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

E4ED3DA9-3B19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

E56F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 10:02:31.577 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

E56F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

E76F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 10:02:32.780 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

E76F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

E96F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 10:02:33.013 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

E96F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

EB6F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 10:02:33.233 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

EB6F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

ED6F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 10:02:33.483 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

ED6F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

EF08B798-3D19-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:05:31.667 0 QueryInventory 0 0 0xFFFE3C005100750065007200790049006E00760065006E0074006F00720079003E003C0042006F006F006B003E0042004B0031003000300031003C002F0042006F006F006B003E003C002F005100750065007200790049006E00760065006E0074006F00720079003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

EF08B798-3D19-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:07:23.993 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

17C33DB5-4019-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:27:48.017 0 QueryInventory 0 0 0xFFFE3C005100750065007200790049006E00760065006E0074006F00720079003E003C0042006F006F006B003E0042004B0031003000300031003C002F0042006F006F006B003E003C002F005100750065007200790049006E00760065006E0074006F00720079003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

17C33DB5-4019-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:34:15.663 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

1B5035AB-4119-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:34:40.680 0 QueryInventory 0 0 0xFFFE3C005100750065007200790049006E00760065006E0074006F00720079003E003C0042006F006F006B003E0042004B0031003000300031003C002F0042006F006F006B003E003C002F005100750065007200790049006E00760065006E0074006F00720079003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

1B5035AB-4119-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:35:53.587 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

3EBD7690-E119-DA11-A660-505054503030 Receiver Sender HelloContract 2005-08-31 05:39:15.287 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.

Thanks

M A Srinivas