Gila, I think I had to explain this way so you can have a better idea about what I am trying to get.

For a certain Publication (which might have...

GilaMonster (4/3/2009)

---

Thang.Nguyen10 (4/3/2009)

---

Sorry guys, I was in the meeting until now. Here is the implicated tables relationship diagram. Is that enough or you need more information on table...

GilaMonster (4/3/2009)

---

This can't be removed, at least until we know why it's there...

Sorry guys, I was in the meeting until now. Here is the implicated tables relationship diagram. Is that enough or you need more information on table definition ?...

Thanks Chris.

As you suggested, I start running your script in Dev environment (where I am the only user) at 10:11am and now is 11:09am, the script is still...

The DBA advise me to create indexes for tblUserDesignees (which has only 2 fields OwnerID and UserID), follow which I create 2 cluster indexes for each of the fields. ...

Dear,

How do I write my trigger to be able to retrieve the SQL statement that used to delete the records ? This is very crucial for...

Christopher, your code worked wonderful.

My question is, why the SQL code was not retrieved by my code ?

DECLARE @raisedEventData XML

SET @raisedEventData = eventdata()

SET @sql = LEFT(cast(@raisedEventData.query ('data(/EVENT_INSTANCE/TSQLCommand/CommandText)') AS...