Microsoft SQL Server: Determine MDAC Version

Posted October 13, 2006 by Rob Rogers in Database

You can easily determine what version of MDAC your are running on your SQL Server by just typing a few lines into the query window. To do this:

1. Open up the query window in your Enterprise Manager or Management Studio.

2. Copy and paste the following:

USE master
EXEC master..xp_regread

3. Execute the query.

The results will give you the version under the Data column.


About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

Leave a Reply