The service 'mySSBQueue' is not found. help me please!!!

  • Thread starter Thread starter xum
  • Start date Start date
X

xum

i run the example of MSDN :
sql:
CREATE QUEUE mySSBQueue
GO
CREATE SERVICE mySSService ON QUEUE mySSBQueue
GO

code:
SqlConnection c = ...; //an open SqlConnection
SqlCommand cmd=new SqlCommand( "SELECT * FROM Authors", c );
SqlNotificationRequest nr=new SqlNotificationRequest();
nr.id="myNotificationID";
nr.Service="mySSBQueue";
cmd.Notification=nr;
cmd.ExecuteReader();

cmd=new SqlCommand( "Update Authors set..."); // generate error
....

question:
when update Authors , i have a error "The service 'mySSBQueue' is not
found."
but why???
if i change nr.Service="mySSBQueue" to nr.Service="mySSService",
the error is "The service 'mySSService' is not found."

please help me,thanks!!!!
 
Back
Top