SQLMail

External Article

Formatted emails from SQL Server

  • Article

Collaboration Data Objects, also called CDO, is designed to simplify writing programs that create or manipulate Internet messages. CDO for Windows 2000 is an integral part of the Windows 2000 and higher series of operating systems. It is easy to send SMTP email from SQL Server using CDOsys. It is an alternate method to SQLMail. This article illustrates how to use CDOSys to send formatted emails from Query Analyzer and SQL Server Alerts.

2005-04-25

4,639 reads

SQLServerCentral Article

How To Configure SQL Mail to Work With Groupwise

  • Article

SQL Server excels in many areas, including the tight integration of it's internal SQLMail system with Outlook and Exchange. But if you want to use another mail system, SMTP, Lotus Notes, or Groupwise, you are left to your own resources to configure your system. Fortunately new author Chris Shepherd has taken time to dig in and document how to get SQL Server to work with Novell's Groupwise mail system. Read about his setup and troubleshooting tips.

2005-01-27

7,801 reads

SQLServerCentral Article

SQL MAIL Using POP3 and SMTP

  • Article

SQL Server has a great build in messaging system with SQLMail. Unfortunately it requires Outlook and Exchange to work properly. Some people don't like this or do not run Exchange and have issues getting it to work. Gregory Larsen takes a look at how you can use SMTP to send email from SQL Server.

2004-11-23

20,805 reads

Technical Article

RE: Insert Performance

  • Reply

If you are attempting to insert data into a table with a clustered index you have to bear in mind that the data has to be moved about a lot to maintain the integrity of the index. I would recommend dropping the clustered index before the insert and then creating it again afterwards, you should […]

2004-04-06

Technical Article

RE: ADO Code

  • Reply

quote: ...unfortunately not the browser merely hangs for a few seconds and then returns a blank page. any error handling routines turned on? BTW, I use this to connect to SQL Server cnnString = "PROVIDER=MSDASQL;" cnnString = cnnString & "DRIVER=SQL Server;" cnnString = cnnString & "SERVER=DCCIV30002004;" cnnString = cnnString & """;" cnnString = cnnString & […]

2003-07-07

1 reads

Technical Article

backup with stop at

  • Topic

Hi I had a backup plan like this - monday to friday : diff - saturday and sunday : full - log every 6 hours everyday Suppose on Wednesday one of my client accidentally change the wrong data. And he realized it on next day. BOL said that i should do the following things: - […]

2001-12-04

1 reads

Technical Article

How can I be a great DBA?

  • Topic

Hi everyone 😀 I want to learn more about being a DBA, what should I do?, where can I go to. I like all about DBA´s, at shcool I learned somethings, right now I am working in analysis and programming software on VB and SQL. Here the DBA don´t have a lot of expirence and […]

2001-11-19

1 reads

Blogs

Advent of Code 2022

By

Foreword Advent of Code is an annual event in which participants solve a series of...

Daily Coping 8 Dec 2022

By

Today’s coping tip is to be curious. Learn about a new topic or an...

#PowershellBasics: Warnings and how to hide them.

By

One of my favorite parts of having a new job is that I learn...

Read the latest Blogs

Forums

The Enterprise Roadmap to Reducing Costs (While Increasing Value)

By Additional Articles

Comments posted to this topic are about the item The Enterprise Roadmap to Reducing...

The Temp Alias

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Temp Alias

Connect to SQL Server with Python to Create Tables, Insert Data and Build Connection String

By Additional Articles

Comments posted to this topic are about the item Connect to SQL Server with...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Temp Alias

See possible answers