
use pubs
GO

-- for notification request
CREATE QUEUE myqueue
GO

CREATE SERVICE myservice
 ON QUEUE myqueue
([http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] )

select * from sys.service_contracts