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,013 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,766 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,690 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
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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