Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile. However, its syntax is rather stringent. In this article by Kunal Das, he shows you how to send messages to a list of recipients generated by a query dynamically in T-SQL.
2007-10-02 (first published: 2001-07-16)
23,966 reads
This article describes how to monitor Microsoft SMTP usage using SQL Server 2000 and XML.
2001-11-29
3,588 reads
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
I’ve been working on a project that combines two things I spend a lot...
Running AI and data pipelines on the edge instead of the cloud has gone...
Are there any good articles on all the trace flags that are enabled on...
Comments posted to this topic are about the item The Data Model Matters
Comments posted to this topic are about the item Understanding SQL Server PARTITION BY...
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers