This is how to do it is you do not have enterprise version of sql server. There are many ways...

Leo Peysakhovich (6/20/2012)

---

"This is a scheduling 'addon' to handle cases where the native scheduling isn't as flexible as is necessary to the specific varying periodicity of this type of data...

"This is a scheduling 'addon' to handle cases where the native scheduling isn't as flexible as is necessary to the specific varying periodicity of this type of data load"

The way...

Agreed with SSC-Enthusiastic. This solution is very danger to implement. Especially in environments where multiple DBAs and database developers controlling jobs in a heavy processing environment. If for some reason...

BobMcC (7/30/2009)

---

Sorry to resurrect this old thread, but I"m in the middle of a project to upgrade our sql 2000 dbs to sql 2008. I'd like to also use...

a) it is allowed to gather additional data via XML

b) it is extended to the way...

a) it is allowed to gather additional data via XML

b) it is extended to the way...

a) it is allowed to gather additional data via XML

b) it is extended to the way...

Mitch Miller (5/21/2009)

---

Sorry LP -- I just had a nice big explanation with examples, and this damn website took it and tossed it. Now I'm pissed. I can't...

You can do it. But I did not add it because I need to be able to get different XML schemas with different namespaces generically. You will see it in...

pvoutov (7/7/2008)

---

I noticed that the author uses this statement to grab the newly inserted identity:

set @INSERTED_IDENTITY_ID = IDENT_CURRENT('HIST_ERROR_LOG');

I think he meant to specify the table 'ERROR_LOG', not 'HIST_ERROR_LOG'. (Correct)

Also,...

i did sent email to steve jones

Ninja's_RGR'us (4/15/2008)

---

Fine, turn the trigger back on, then PRINT the query instead of executing it.

Analyse that query and you'll find your problem there.

Also you are asking for troubles by auditing...

Check field tblnm varchar(50) and variable @tblname VARCHAR(128)

Msg 8152, Level 16, State 14, Procedure p_trigger, Line 61

String or binary data would be truncated.

The statement has been terminated

This message means that the string data you trying store in...