Thanks Lowell for pointing me out on a DML trigger on the sysjobs[...] tables.

I'll give it a try and let you know the results.

Now, if a DDL event exists for...

English is not my mother tongue, but I definitely liked the way you wrote this article 😎

Of course thanks for the tips and we currently don't audit the logins. It's...

Thanks Rudy for sharing this very useful report. You did a great job!

As many of us, my servers did not pass all the checks 😉 This is not an issue...

Thanks a lot for sharing your experience. I personally did not know/remember about sp_helptext, but I'm sure it will help me a lot in the future ...

🙂

I did not find a way yet to force typeperf to fire triggers when bulk inserting. Nor did I find a way to tell the ODBC connection to do so.

So...

emil.bialobrzeski (8/29/2014)

---

Hi rot, i know this is a silly question, but...

GilaMonster (8/29/2014)

---

A manual insert (INSERT INTO) absolutely will fire triggers, no way that...

I added manually a record to the table but it did not fire the trigger either ?!?

I'm very puzzled!!!

Here's the code ...

insert bulk CounterData("GUID" uniqueidentifier,"CounterID" int,"RecordIndex" int,"CounterDateTime" char(24) COLLATE SQL_Latin1_General_CP1_CI_AS,"CounterValue" float,"FirstValueA" int,"FirstValueB" int,"SecondValueA" int,"SecondValueB" int,"MultiCount" int)

OK

I changed the ODBC connection to store the data on a new database, but it...

Thanks for your answers ...

@venonym: I'll try to check whether triggering is enabled for the database/table ...

@gilamonster: the rows are added by the DOS command TYPEPERF with an...

Jeff Moden (7/28/2014)

---

I totally disagree as written above especially when it comes to private information such a Social Security Numbers. It [font="Arial Black"]MUST [/font]be proven if it exists and...

I fully agree with you and that's what I did earlier ... however most of the people...

Evaluateasexpression is set to true

ran the profiler and @[User::ClientID] is not evaluated.

I'll look back into it on tuesday.

anyway, thanks for your help koen, I'll keep you informed ...

ok, I understood what you meant and have put the SQL query in a variable executed in the Execute DQL Task.

Unfortunatly still the same error. It seems it does not...