Chris Kempster

Chris has been working in the computer industry for around 8 years as an Application Development DBA. He began his career as an Oracle AP then moved into a DBA role using Oracle. From there he has specialised in DBA technical consulting with a focus to both Oracle and SQL Server. Chris has been actively involved with SQL Server since 1999 for a variety of clients and is currently working with a range of large scale internet based development projects.
Visit www.chriskempster.com for further information and his ebook titled "SQL Server 2k for the Oracle DBA".
  • Interests: Mt Biking, playing with my young kids, and IT

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

371 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,519 reads

Blogs

Daily Coping 15 Jan 2021

By

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

Another One Bites the Dust - PASS is Gone, so...What Now?

By

There has been a lot of noise over the last few weeks since it...

SQL Server Linux

By

If you have come from a windows background you may be curious about the...

Read the latest Blogs

Forums

DB corruption error 8905, fixed using repair_allow_data_loss ,

By huishi.ca

hi all, I need some help here. Recently, I've found a db with error...

Grouping AND OR Logic

By Stavros_McGillicuddy

I am trying to use this logic ((1 OR 2) OR 6 OR 7...

alternative to temp tables with 3M+ records and growing

By ricky969

I'm struggling with the performance of one of my stored procedures. Depending on the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers