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,008 reads

Blogs

Containers: Working With Volumes

By

In the previous two posts on containers I showed how use Docker commands to...

Speaking at PASS Summit 2019

By

I am delighted to announce that I have been selected to speak at the...

High Security Prices–Always Encrypted 2019 needs Datacenter Edition

By

I was recently doing some work on Always Encrypted in SQL Server 2019 and...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Query help on Pivoting on two columns

By s-sql

DECLARE @RegionCounts Table ( TYear char(2), Region varchar(30), RowCnt int ) Insert into @RegionCounts...

Response to Bloor article on SQL Provision

By gbritton1

I found the article https://www.sqlservercentral.com/articles/bloor-scores-sql-provision-4-5-out-of-5-for-test-data-provisioning Interesting if a little shallow.  It would be more...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers