Kevin Terry


SQLServerCentral Article

Coupling Outlook to SQL Server

SQL Server has drivers to read almost any data source, but they are not always the easiest to work with. New author Kevin Terry spent quite some time learning how he could pull data from Outlook using DTS and scripting. Most information on the internet requires Exchange to be on the same server as SQL Server to get the data, but this solution works with any configuration, and can pull any information, email address, contact information, etc. from Outlook.

5 (1)

You rated this post out of 5. Change rating

2005-02-01

18,545 reads

Blogs

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Read the latest Blogs

Forums

Using AI for Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using AI for Security

Writing to Clones

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Writing to Clones

Live webinar: How to excel at managing multiple database platforms

By Press Release

Comments posted to this topic are about the item Live webinar: How to excel...

Visit the forum

Question of the Day

Writing to Clones

I run this code on SQL Server 2019:

DBCC CLONEDATABASE(imdb, imdb_dev)
I then change to the cloned database, imdb_dev, and run some queries. I then run this code while testing:
INSERT dbo.Title (TitleID, Title, DateReleased) VALUES (3234, 'Maestro', '2023')
GO
What happens?

See possible answers