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.
| Author |
Topic |
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
 Posted - 2008-06-12 : 14:47:34
|
| I want to write a trigger that gets invoked if a particular table is created in the database. Say we're discussing the AdventureWorks database and we want to create a table called EuropeanCustomers. How would I specify that the trigger should only be invoked on this table, not for all create DDL statements?Thank you in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-12 : 14:55:09
|
| DDL triggers are not supported in SQL 2000. |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-06-12 : 15:25:43
|
| Devil, your post makes no sense. I can't tell from it whether you are talking about DDL triggers or data triggers.e4 d5 xd5 Nf6 |
|
|
|
|
|
|
Trigger on Create for a particular table