Ok, thanks for your time.

Hi Grant,

Thanks for that comment, but the trace is actually writing to a file on a separate physical disk, the the StopPerfTrace SP reads it in using fn_trace_gettable.

I am pretty...

have you tried starting SQL with the -f switch?

-f

Starts an instance of SQL Server with minimal configuration. This is useful if the setting of a configuration value (for example, over-committing...

Can I please ask why you need the output in a certain order?

XML is not normally used in that way (at least not in my experience) and I find it...

No, sorry I never use that.

You are referencing the node incorrectly. Try this (the text() function is used because it is slightly quicker ):

DECLARE @xmlString XML = N'<TAG1><A>1</A><A>2</A><A>3</A><A>4</A><A>5</A><A>6</A></TAG1>'

SELECT doc.col.value('./text()[1]','INT') AS A

FROM @xmlString.nodes('/TAG1/A')doc(col)

Would it work? That all depends - if those were the only two triggers in use then yes - if you get rid of the ELSE - it is not...

I would code the front end to check for duplicates and warn the user.

You won't get anything useful from a trigger unless you have a "known duplicate" column in the...

OF course, if those are the real triggers, then are you not showing us the delete from the "other" database table in the first trigger?

Just checking because it won't work...

ae_from_pa (2/3/2011)

---

How would the context setting be placed? For example, should it work if my first trigger (modify stmt) starts out like this:

======

ALTER TRIGGER [dbo].[UPDATE_EMAIL_IN_HEAT] ON [dbo].[CONTSUPP]

FOR...

Did you read the code I posted - that will do what you want....?

Sorry I don't see why you need to Loop one row at a time.

I am sure if you explain what you are trying to do someone will come up...

To add some more context to the trigger would help...

In your first database, use

DECLARE @ci VARBINARY(128) = CAST(DB_NAME() AS VARBINARY(128));

SET CONTEXT_INFO @ci;

And in the second, use:

IF CONVERT(VARCHAR(50),CONTEXT_INFO()) <> DB_NAME()...

Hi, did you try this?

IF TRIGGER_NESTLEVEL()>1 RETURN

Thanks for the article.

I personally was disappointed to find that it was not about rebuilding the master database as the title said it would be though...