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

An Introduction to the Service Broker Part 2 Expand / Collapse
Author
Message
Posted Tuesday, August 16, 2005 12:40 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 28, 2005 7:13 AM
Points: 18, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sSampath/anintroductiontotheservicebrokerpart2.asp

HTH,
Srinivas Sampath
Blog: http://blogs.sqlxml.org/srinivassampath
Post #210990
Posted Tuesday, August 30, 2005 4:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 03, 2006 8:52 PM
Points: 100, Visits: 1

Srinivas Sampath

 

I tried your code . But when I give

SELECT * FROM InventoryPostBox , I am not getting any output.

Any other settings need to be enabled at server / database level

 

Thanks

M A Srinivas

 




M A Srinivas
Post #215212
Posted Tuesday, August 30, 2005 11:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 28, 2005 7:13 AM
Points: 18, Visits: 1

It could be an issue with Service Broker. Execute the following query: SELECT * FROM sys.transmission_queue and see if there is any error that is logged there. If so, send me the error text and I will tell you what to do.



HTH,
Srinivas Sampath
Blog: http://blogs.sqlxml.org/srinivassampath
Post #215373
Posted Tuesday, August 30, 2005 11:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 03, 2006 8:52 PM
Points: 100, Visits: 1

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

 




M A Srinivas
Post #215540
Posted Wednesday, August 31, 2005 12:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 28, 2005 7:13 AM
Points: 18, Visits: 1

Ok. The security was tightened in the June CTP build of SQL Server. Read my blog at: http://blogs.sqlxml.org/srinivassampath/archive/2005/06/19/3457.aspx on how to get over this issue.



HTH,
Srinivas Sampath
Blog: http://blogs.sqlxml.org/srinivassampath
Post #215541
Posted Wednesday, August 31, 2005 12:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 03, 2006 8:52 PM
Points: 100, Visits: 1

Srinivas Sampath,

 

Thank you for quick response . It is working now .

By the way how do I download Visual Studio Beta 2 through msdn subscription . Not able to find the URL

 

Thanks

M A Srinivas

 




M A Srinivas
Post #215544
Posted Thursday, September 01, 2005 11:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 28, 2005 7:13 AM
Points: 18, Visits: 1

If you get MSDN subscriptions through a media, its there.



HTH,
Srinivas Sampath
Blog: http://blogs.sqlxml.org/srinivassampath
Post #216411
Posted Tuesday, February 12, 2008 5:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 29, 2010 12:34 AM
Points: 4, Visits: 16
Hi Sampath..can u pls. give an example of service broker sending transactions across different databases with ROUTES. Can it be replacement of replication?

Thanks,
Kingshuk
Post #454350
Posted Thursday, July 01, 2010 4:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 01, 2010 11:16 PM
Points: 1, Visits: 2
hi, Now I encounted same problem, can you tell me how to resolve that . thank you .
BTW, http://blogs.sqlxml.org/srinivassampath/archive/2005/06/19/3457.aspx I can't open it .


thank you very much.
Vincent
Post #946064
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse