Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 

64 Results Found

SCRIPT

E-Mail Validator

... pass a field which contains an e-mail address to the function and either a 1 (valid ... encompassing solution for identifying invalid e-mail addresses, but rather a quick / easy check ... run the function: SELECT dbo.ufn_E_Mail_Validator ('me@nowhere.com') AS is_valid_yes ,dbo.ufn_E_Mail_Validator ('me@@nowhere.com') AS is_valid_no Or... against ...

SCRIPT

Resend failed mail.

Script tries to resend all mails that has failed for the last @DaysBack days ...

SCRIPT

Send Query Result as HTML Mail

... 2000. This script use CDOSys to send a mail. No mapi profile required. The query result ...

SCRIPT

SQL SERVER 2005 SQL MAIL

... configure you database to use sql mail for sql2005.

SCRIPT

Enable and configure DB mail using T-SQL

Use this to enable and setup database mail in sql server 2005/2008

SCRIPT

Changing database mail account SMTP servers

... script that drops and recreates existing db mail accounts and change the smpt server.

SCRIPT

Sending Job Failed Information Through E-Mail Using T-SQL

... Job Failed Information Through E-Mail Using T-SQL.

SCRIPT

Send Mail

... cdosysmail @To (varchar(2048)) - Recipient e-mail address list separating each with a ';' or a ','. Use ... nothing @Subject (varchar(255))) - E-mail subject. The default is a message from @@servername ... above example will send an smpt e-mail to <user@mycompany.com> from @@ServerName with a subject of 'Message ...

SCRIPT

Get an alert whenever SQL Server restarts

... Prerequisites for this job:- Make sure Database Mail should be configured. Usign the Script:- 1. add the mail id in "add mail id here" 2. Execute the script ... server. 5. check the alert in your mail.

SCRIPT

Send mail fromĀ  SQL Server using Jmail

... tool can obtain it in http://www.dimac.net/ Mail in format HTML or TEXT can be sent ... archives. It is a tool to send and to receive electronic mail from any PC or SERVER without the use of a program of mail or a mail server as Eudora, Exchange or Outlook