UserData When Using SqlNotificationRequest

Nov 22, 2006

Hi,

The MSDN talks about using SqlNotificationRequest.UserData as an "application-specific identifier for this notification". However we could not figure out how to extract the user data when the ExcuteReader() returns from the queue. The UserData we used was nowhere in the reader fields (we went as far as looking at the queue's fields in SQL server itself).

Where can we find it?

View 4 Replies


ADVERTISEMENT

SQLDependency, SqlNotificationRequest XML

Jun 6, 2007

Hello i'm a beginner with SSB. I wandering how can i retreive data when change occured on a specific table. At this time i'm able to receive a notification when data has changed on my table but if i would like to check data change on several table how to make it work??



I think meta data can be accessible in xml format but i have to clear idea on how retreive changed row information and table name from meta data.



I Suppose this can be achieve with SSB



Any help will be appreciated...

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved