locked
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

Answers

  • 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.

    HTH...

    Joe

    Wednesday, October 15, 2008 12:00 PM