SQL Mail Stop and Start

Since SQL Mail periodically stops working and the simplefix is to stop and start it, this script does just that.It can be scheduled to run as a task as often as desiredusing an ISQL command (e.g. isql -U sa -P  -i "e:\dba\mailstopstart.sql" -o "e:\dba\mailstopstart.out")or as a stored procedure.  It has been tested on SQL 6.5 […]

2002-05-16

1,043 reads

Blogs

The First Data Saturday is Tomorrow

By

Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...

Daily Coping 22 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 21 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Aliasing an instance name for remote connections

By Brandie Tarvin

It's been a long time since I set up a 2012 server. We have...

Looking for tips on Optimizing

By Mr. Brian Gale

I am probably going about this the wrong way, but my current solution is...

Snapshot Folder is not deleting automatically in Transactional Replication.

By dastagiri16

Hi Team, I created transnational replication to replicate the data from one server to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Amend a Commit

See possible answers