UDF to find MDAC version

,

This UDF returns the MDAC version

print dbo.MDACversion()

CREATE FUNCTION  MDACversion ()
RETURNS varchar(255) AS  
BEGIN 
DECLARE @Ver varchar( 255 )
EXEC master..xp_regread N'HKEY_LOCAL_MACHINE',
	N'Software\Microsoft\DataAccess',
	N'FullInstallVer' , @Ver OUT , N'no_output'
RETURN (@Ver)
END

Rate

Share

Share

Rate