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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-04 : 07:11:14
|
| Muhammad Alam writes "I am going to create my first trigger. I have a question for future effects made by trigger.Will the trigger fire, whenever i run import/export on the table (table having trigger on INSERT).Will wait for your reply." |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2003-02-05 : 08:10:46
|
| Yes ANY time you insert data, IMPORT included, then the trigger will fireEXPORTing from the table then no===========Paul |
 |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2003-02-05 : 08:54:15
|
quote:
Muhammad Alam writes "I am going to create my first trigger. I have a question for future effects made by trigger.Will the trigger fire, whenever i run import/export on the table (table having trigger on INSERT).Will wait for your reply."
By default the trigger will fire but you can disable triggers via the alter table statement. |
|
|
|
|
|
|
Import/Export.