[font="Verdana"]I think the OP is asking what the name of the table is that DTS logs output to. I think. I could be wrong.[/font]

tosscrosby (1/29/2009)

---

You never will here. Passionate people about SQL server, all willing to help whenever possible (free of charge!), some...

[font="Verdana"]In my experience, a "senior" role isn't the one occupied...

[font="Verdana"]Just curious...

Did anyone try writing a C# function to do the same job? It would be interesting to see comparible performance figures.

[/font]

Jeff Moden (1/28/2009)

---

[font="Verdana"]See limitations of my...

[font="Verdana"]This is where you hit the limitations of my memory. I know there is a way to do it (i.e. get access to the data that has changed), because...

matt stockham (1/28/2009)

---

Bruce: thanks for the quick reply.

It's not exactly what I expected, in that by using FOR EACH ROW it's no longer a set-based trigger ie one...

gints.plivna (1/28/2009)

---

Some comments for various posts:

I'm reading it almost every day I produce any code. tahiti.oracle.com then is my starting point and I've...

[font="Verdana"]The Oracle create trigger syntax is as follows:[/font]

[font="Courier New"]

CREATE [OR REPLACE] TRIGGER

{BEFORE|AFTER} {INSERT|DELETE|UPDATE} ON

[REFERENCING [NEW AS ]]

...

[font="Verdana"]Yes. Up until you run into the size limitation of...

[font="Verdana"]I've used both extensively. I prefer some of the options available with Oracle for high-end datawarehousing, but SQL Server is rapidly playing catch up there. Generally speaking, I...