Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 view with a trigger on select

Author  Topic 

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2009-01-13 : 13:09:33
I'm wondering if something like this is possible ?

a view with a trigger on select?

Any help appreciated !

thanks,
mike123

Skorch
Constraint Violating Yak Guru

300 Posts

Posted - 2009-01-13 : 13:32:21
Nope, sorry. Triggers can only be created for inserts, updates or deletes.
Go to Top of Page

rohitkumar
Constraint Violating Yak Guru

472 Posts

Posted - 2009-01-13 : 15:29:55
and why do you need such trigger on a view?
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-13 : 15:57:38
Create a profiler trace instead...

- Lumbago
Go to Top of Page
   

- Advertisement -