How to use Database mail feature in SQL Server 2000
This article describes a way by which we could use the feature of database mail in SQL Server 2000 itself which is a lot easier than SQL Mail.
2010-03-09
8,098 reads
SQLMail
2009-10-31
1 reads
2009-06-30
3 reads
Formatted emails from SQL Server
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
How To Configure SQL Mail to Work With Groupwise
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
SQL MAIL Using POP3 and SMTP
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
RE: Insert Performance
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
RE: ADO Code
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
backup with stop at
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
How can I be a great DBA?
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 Zikato
Foreword Advent of Code is an annual event in which participants solve a series of...
Daily Coping 8 Dec 2022
By Steve Jones
Today’s coping tip is to be curious. Learn about a new topic or an...
#PowershellBasics: Warnings and how to hide them.
One of my favorite parts of having a new job is that I learn...
Forums
The Enterprise Roadmap to Reducing Costs (While Increasing Value)
Comments posted to this topic are about the item The Enterprise Roadmap to Reducing...
The Temp Alias
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
Comments posted to this topic are about the item Connect to SQL Server with...
Ask SSC