Friday, February 02, 2007 8:54 AM
A few months ago, Red-Gate made its famous product SQL Prompt free which is not the case anymore. So, if you still have the installer that you might have saved, it'll be still "free" for you. :)
If you are using WinXP/SP2 with SQL Server 2005 and try to install SQL Prompt, it will complain that you need MDAC 2.8 or higher. This is probably the installer glitch. With SP2 of WinXP, you already have MDAC 2.8 SP1 or highter I believe.
The workaround as per this:
- Go to registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess
- Add/modify String Value called FullInstallVer with value 2.80.1022.3
- Run the installer SQLPromptSetup.exe and you should be good to go.
Enjoy SQL Prompt...one of the best tools for SQL Server.