/* FileSpec = "\\SQ-SQLD101\C$\WINNT\system32\aaaamon.dll" Set fso = CreateObject("Scripting.FileSystemObject") Set oFile = fso.GetFile(FileSpec) fso.GetFileVersion(oFile) */ declare @FileSpec varchar(255), @Version varchar(15) set @FileSpec = 'C:\WINNT\system32\ver.dll' declare @oFSO int, @oFile int declare @hr int declare @src varchar(255), @desc varchar(255) exec @hr = sp_OACreate 'Scripting.FileSystemObjec', @oFSO OUT if @hr <> 0 begin exec sp_OAGetErrorInfo @oFSO, @src OUT, @desc OUT Goto ErrorHandler end exec @hr = sp_OAMethod @oFSO, 'GetFileVersion', @Version OUT, @FileSpec if @hr <> 0 begin exec sp_OAGetErrorInfo @oFSO, @src OUT, @desc OUT Goto ErrorHandler end exec @hr = sp_OADestroy @oFSO if @hr <> 0 begin exec sp_OAGetErrorInfo @oFSO, @src OUT, @desc OUT Goto ErrorHandler end select @Version ErrorHandler: select @hr select @src select @desc