AFTER - trigger

What do you think the following mean:
"You can define AFTER triggers only on tables. And you can create any number
of AFTER triggers on a view or table"That certainly is contradictory. It is the first sentence that is correct.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:uUQB6Jr7HHA.1484@.TK2MSFTNGP06.phx.gbl...
> What do you think the following mean:
> "You can define AFTER triggers only on tables. And you can create any number
> of AFTER triggers on a view or table"
>|||There are other mistakes in that book too Alan.
For instance, it says that you can setup Cluster on a Windows Server 2003
Standard Edition, which is not correct either. You may setup a (at most) 2
node Cluster using SQL Server 2005 Standard Edition, but Windows Server 2003
Standard Edition will not do that. You must use Windows Server 2003
Enterprise or Datacenter Editions to setup Cluster on Windows Server System.
--
Ekrem Önsoy
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:uUQB6Jr7HHA.1484@.TK2MSFTNGP06.phx.gbl...
> What do you think the following mean:
> "You can define AFTER triggers only on tables. And you can create any
> number
> of AFTER triggers on a view or table"
>|||On Tue, 4 Sep 2007 15:14:30 +1000, Alan T wrote:
>What do you think the following mean:
>"You can define AFTER triggers only on tables. And you can create any number
>of AFTER triggers on a view or table"
>
Hi Alan,
To add on to Tibor's reply, allow me to add that you can defined
* Any number of AFTER triggers on a table
* No AFTER triggers on a view
* At most one INSTEAD OF trigger for each operation on a table or a view
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis