Import

Importing data using
Insert into...
Select from....
Problem is triggers fire only once. Cannot change triggers. Is there any
way to import data so triggers fire for each record?
The trigger has a bug. Triggers fire once for each modification *statement*, not once per row. Seems
like your trigger doesn't handle multi-row modifications (there's a chapter about this in Books
Online). One option is to write a cursor to loop the table and for each row do a single row insert.
It will perform horribly, btw...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"docsql" <docsql@.noemail.nospam> wrote in message news:OZMhCiAUFHA.2820@.tk2msftngp13.phx.gbl...
> Importing data using
> Insert into...
> Select from....
> Problem is triggers fire only once. Cannot change triggers. Is there any way to import data so
> triggers fire for each record?
>
>