anushahanna
asked on
MSOLAP version
how can you find out what version of MSOLAP is being used in the system, for SQL Server.
thanks
thanks
ASKER
for
exec master..xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE\Microsoft\OLAP Server\CurrentVersion', 'VersionNum'
i get
Value Data
VersionNum 0
i was hoping to see 2/3/4
exec master..xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE\Microsoft\OLAP Server\CurrentVersion', 'VersionNum'
i get
Value Data
VersionNum 0
i was hoping to see 2/3/4
Try this -
master..xp_regread 'HKEY_CLASSES_ROOT', 'MSOLAP\CurVer', '(Default)'
master..xp_regread 'HKEY_CLASSES_ROOT', 'MSOLAP\CurVer', '(Default)'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
really smart- thanks reb.
exec master..xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE\Microsoft\OLAP Server\CurrentVersion', 'VersionNum'
If you need the information for the dll, if you can do a manual search in the registry, then using the root, key and valuename parameters with xp_regread should give you the value