Chris Kempster

Generate Restore DB Scripts from prev backups v1.0

Using the the MSDB backup tables, will generate the basic disk RESTORE commands for a database. It will include the Full, differential and all associated log recovery commands for you. Run the stored proc in Query Analyser then copy/alter the output to recover your DB. Great if using EE is not your cup of tea. […]

2002-01-03

368 reads

Email using CDONTS (via smtp)

Here is a very basic example script for sending emails via CDONTS. This comes from the sqlmag web-site forum. Although fine, remember that it will use the local SMTP server to forward emails onto the destination user. If your servers smtp process can not reach an exchange/group-wise/other mail box on your network, then this code […]

2001-08-09

3,514 reads

Blogs

Being a Woman in the SQL Community

By

In celebration of Women’s History Month starting next week, I was asked to write...

Join me at SQLBits 2020

By

The SQLBits conference is taking place in London again this year, between March 31st...

DBA, a job, a vital job

By

DBA, a job, a vital job. T-SQL a language that is fun. Select, a...

Read the latest Blogs

Forums

How to make DBCC CheckDB faster ?

By WhiteLotus

Hi All We are running DBCC CheckDB in our server during low activity time....

Exploring the DATE Functions in SQL

By aveek22

Comments posted to this topic are about the item Exploring the DATE Functions in...

Implementing Date Calculations in SQL

By aveek22

Comments posted to this topic are about the item Implementing Date Calculations in SQL,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers