Good grief. Yeah, I didn't even think about the capability of something coming before the INSERT/UPDATE/DELETE in the string. <facepalm>

And your modification works great! Many, many thanks!

My...

Lowell,

Alright...I tinkered with the code you sent us & came up with this "alpha" code I will pick at tomorrow. Do you see anything initially wrong with going this...

Lowell,

Will this code work on DELETES as well? I'm picking this apart as we speak but thought I'd ask before I spend a lot of time on this...

Lowell,

This piece of code has been gold for me in a couple of other triggers. Thank you again.

The instance I am having issues with at this time is using...

Lowell,

Thank you! This is just what we're looking for! Testing so far is working great!

Now I'll pick it apart to see how you did this.

Thanks again!...

Finally approached our server email admin & explained my dilemma to him. He unchecked the requires authentication box, and once the server was propagated with the information it worked...

Using your code came up with blanks...even immediately after sending a group email.

anthony.green (3/30/2012)

---

by default everything will be created in DBO unless one of two things, you explicitally give it a different schema or your default schema is different than dbo on...

I found out for this particular server, we're using SQL...

Lowell (6/10/2010)

---

another option would be Merge Replication, now that i'm thinking about it;

changes would get shipped out on a regular basis, and once set up, you do not have to...

Lowell (6/10/2010)

---

I think there are few ways to go about this;

1. have the trigger directly update the other server. this assumes a linked server exists to the other server. downside:...

Okay....I'm about 95% of the way there. Here's what I've come up with so far.

If I run this....

Select @DBName = EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')

I get this if I print @DBName....

"ALTER DATABASE [JW_Ref_Tools]...

PaulB-TheOneAndOnly (6/3/2010)

---

John Waclawski (6/3/2010)

---

PRINT '*************************************************************'

PRINT 'If you need to Add/Delete/Modify a database on this server,'

...

This following code executes with no problems. I get the print statements & the email (when it's not commented out) but the ROLLBACK doesn't work. After sleeping on...

Coincidentally I've been using that one all day working on my issue. 😀

Found this one as well. Still reading it.