Mathematical Auditing Of Email Broadcasts
In a sequel to his previous article on referential integrity, Glen Cooper looks at some ways to analyze who is getting emails based on a database system.
2009-05-22
4,218 reads
database mail
Database Mail and SQL Agent Mail setup by using a script
In this tip I provide a script with a few parameters that need to be setup to configure and turn on both of these features.
2009-05-11
4,009 reads
Setting Up Database Mail - SQL School Video
Learn how to get started integrating mail with your SQL Server in this SQL School video. MVP Andy Warren shows how to set up Database Mail.
2009-04-28
5,212 reads
Dynamically getting mail profile for sp_send_dbmail
I have found that I like to generate a script once and roll it out to multiple servers at the same time. SQL Server 2008 Management Studio makes that fairly easy by allowing one window to connect to multiple instances simultaneously
2009-01-27
1,518 reads
Configuring Database Mail in SQL Server 2005
Learn how to set up SQL Server Database Mail in SQL Server 2005. In this tip, you'll see how to configure Profiles and Accounts for sending mail.
2008-08-11
3,914 reads
Get DBMail information
get the profile name and the account name etc about the dbmails created on the server
2008-09-12 (first published: 2008-07-13)
975 reads
What do you do with a new SQL Server?
This article highlights some basic steps to take when you have a new install of SQL Server or take over support of existing databases.
2008-06-12
7,786 reads
2005-04-06
error when adding a new field
I have a production database running as the backend to a ColdFusion application. In the past 2 months, when I add any new fields, the application throws this message: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. It doesn't matter what data type the field is or what table […]
2005-03-10
RE: Recommendations for a Query Analyzer replacement
Hi Frank,It would be worth your time to investigate our ApexSQL Edit product. http://www.apexsql.com/sql_tools_edit.htm Apex SQL Tools has started a blog to list development progress of Apex SQL Edit, SQL Database Tool for SQL editing. Apex SQL Edit is a SQL Tool integrated development environment (IDE) for SQL Server including powerful SQL Database development capabilities, updated […]
2005-02-14
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers