
July 31st, 2007, 08:29 AM
|
|
Registered User
|
|
Join Date: May 2007
Posts: 2
Time spent in forums: 53 m 24 sec
Reputation Power: 0
|
|
|
Is this type of trigger on a view possible?
Hi to all,
just a quick question.
Is it possible to have some live check on a view that the instance any data is present in the view a store procedure is invoked.
e.g. if i have a customer list and a view on a report which contains all the newly entered customers, thus for a any newly eneterd customer how can i have the view react by running a stored procedure upon the instance it has a new row within it.
Any ideas?
Also i'm trying to avoid the use of an SQL server agent job to check the data i'm looking for something thats reactive not pre-empted.
Cheers
|