sql server notification services:
Hi Jedi -
NSControl will build a couple of new databases for you, the Main and the
application databases. Your SQLNS app must use these databases as their
core databases.
You can write triggers on tables in your database to call sprocs in the
SQLNS application database when events occur that require notifications.
For example, if creating a new customer should trigger a notification to
a manager, create an insert trigger in your database that calls the
application database sproc that injects a new event in the SQLNS app
database. SQLNS will take care of the rest for you.
You can also use the built in SQL event provider to periodically query
your database table and look for changes. The choice is yours.
HTH...
Joe Webb
[quoted text, click to view] Jedi wrote:
> hi everyone,
> i am new on NS, i have read all MSDN article about for my custom
> application, i also discused sapmles that i have run. now time to jump into
> code :), here is the scenario, i woul like to NS with my exist MS SQL Server
> Database (all ready created) to send notification as mail
> -How i can integrate new NS application With exist database, when i run
> samples it creates tables automatically, how i can create relation to new
> created tables for application.
> - what shoul do to watch event at a table or column in a table
> - what is the minimal appADF.xml file requirements
>
hi everyone,
i am new on NS, i have read all MSDN article about for my custom
application, i also discused sapmles that i have run. now time to jump into
code :), here is the scenario, i woul like to NS with my exist MS SQL Server
Database (all ready created) to send notification as mail
-How i can integrate new NS application With exist database, when i run
samples it creates tables automatically, how i can create relation to new
created tables for application.
- what shoul do to watch event at a table or column in a table
- what is the minimal appADF.xml file requirements
