HomeDatabaseMicrosoft SQL Server: Determine MDAC Version

Microsoft SQL Server: Determine MDAC Version

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
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\DataAccess',
N'Version'

3. Execute the query.

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

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android