Viewing 15 posts - 4,201 through 4,215 (of 7,636 total)
OK, I found it. "sp_send_dbmail" is the equivalent procedure for Database Mail.
December 29, 2008 at 9:47 am
By the way, "xp_sendmail" uses SQL Server Mail. You should be using Database Mail instead. You definitely do not want to be using SQL Server Mail from within...
December 29, 2008 at 9:44 am
I think that all you have to do is execute a "ROLLBACK TRAN" in the trigger.
December 29, 2008 at 9:40 am
You should probably add this as a reply to an existing thread.
December 29, 2008 at 9:36 am
Jim Russell (12/22/2008)
Do you think we could convince Steve Jones to allow .sqlplan attachments?
sqlplan files can be attached as .TXT files.
December 29, 2008 at 9:26 am
ta.bu.shi.da.yu (12/29/2008)
Hmmmm... I think I'm going to definitely test this one out myself!When I do I'll post my results.
Now that is something that I think Jeff & I will both...
December 29, 2008 at 8:29 am
Christian Buettner (12/29/2008)
Hi RBarryYoung,Why do you think it is not a statement terminator?
Still waiting for your response to my question:
RBarryYoung (12/28/2008)
Christian Buettner (12/28/2008)
I might be nitpicking here again, but the...
December 29, 2008 at 8:23 am
glad we could help.
December 28, 2008 at 10:42 pm
Jeff Moden (12/28/2008)
I just didn't want people to walk away from this post thinking that the myth of performance using WHERE EXISTS had any validity to it, whatsoever.
I am not...
December 28, 2008 at 8:43 pm
Jeffrey Williams (12/28/2008)
December 28, 2008 at 8:17 pm
Christian Buettner (12/28/2008)
The reason they implemented this now is that the WITH has more than one meaning.
Actually, I doubt that that is the reason, otherwise why would SEND &...
December 28, 2008 at 7:25 pm
Christian Buettner (12/28/2008)
Putting the semicolon in front of the WITH just adds additional confusion.
This is only true if all of the other SQL statements in the same procedure or script...
December 28, 2008 at 5:22 pm
Christian Buettner (12/28/2008)
Jeffrey Williams (12/28/2008)I might be nitpicking here again, but the semicolon is required after the preceding statement, not before the WITH statement.
[Of course the end result is a...
December 28, 2008 at 5:13 pm
Viewing 15 posts - 4,201 through 4,215 (of 7,636 total)