Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old July 31st, 2007, 08:29 AM
wjunk wjunk is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2007
Posts: 2 wjunk User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > Is this type of trigger on a view possible?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway