SQLRandall did this idea work for you? I'm using a derivation of this technique to create a trace on the startup/restart of the server; i add a DML trace, and...

if we are going to help with syntax, you have to paste the entire script you are trying to use.

remember we are not standing in your cubicle looking over your...

what you would need is just a variation of the above example, but with the three foreign key columns involved; can you paste the definition of the primary key/unique constraint...

please try both code snippets i pasted; one does exactly what you are asking by putting a...

the code i posted above has both examples: pasting the results of a SQL inline the html body, or as an attachment.

take a look at the lower example i pasted,...

my recommendation is to simply fix the trigger so you don't have to work around your errors; we can certainly help and offer advice and testable scripted solutions.

paste the trigger...

well it sounds like th trm_cde is a lookup value, correct?

so that table which contains all the possible trm_cde would have foreign keys from those 80 other tables, right?

one of...

theres an application out there called What's Up!, which does what you are asking for...tests servers and services on those servers, and notifies people if anything goes down.

last i heard...

ok, still not an issue; read the file from the database, and recreate the view as needed:

--we want the current trace folder

declare...

what i would suggest do is on the server itself, create a VIEW that selects the data from the trace; the view would run under the context of the owner...

why cant you just use find and replace in a text editor or SSMS before you run the command? there cannot be that many defaults you have to change; just...

and this command still works with the missing WITH in 2005/2008;...

the UPDATE command is really misleading...it only identifies if the column was specifically listed int eh column names of the update. It does not tell you if it changed or...

I agree with Coldcoffee; no significant difference.

Also i think i read in the future versions directives like that in the future will require the "WITH (nolock)" format, instead...