Notification service for already existing table in database RRS feed

  • Question


    Hello All,


    I have created Notification service in my SQL server instance but the problem is I mentioned event class in ADF file and it generates a table for that event in Notification service datbase.

    I have already my company's database and there is one table over there and I want to use fileds from that table in my event class of notification services, rather to go ahead and let notification service to create a table in its own database.


    please give me the solution if anyone knows the solution for this problem.

    Wednesday, October 8, 2008 9:06 PM


  • You're right, SSNS will create a series of objects to support its internal operations. You can control where those objects are created (SSNS database or another pre-existing database) and the schema of those objects, but you cannot preclude them from being created.

    It sounds like the other table you mentioned would be a good source of events using the built-in SQL Event Provider.



    Wednesday, October 15, 2008 12:00 PM