Description: Current code allow to list hardware specification of all harddrives on the machine where installed MSSQL 2000/2008
INstruction how to Install:
1. put EpsDiskId.dll to BINN folder
2. register on SQL server:
USE MASTER
GO
sp_addextendedproc xp_DiskId , EpsDiskId.dll
go
3 Usage: exec master..xp_DiskId
4. result:
disk id model serial number hash of drive information
0 Maxtor 6L300R0 L6335HFG 4935207888661319327
1 WDC WD10EADS-00M2B0 WD-WCAV51548340 2424319558569305988
2 WDC WD10EAVS-00D7B1 WD-WCAU46189947 2606938069934380689
3 WDC WD20EARS-00MVWB0 WD-WCAZA6301810 -3528246010576773584
4 ST31000528AS 9VP07G80 2316721070316281990
5 WDC WD20EARS-00MVWB0 WD-WCAZA2933154 6944437904198336381
6 WDC WD10EADS-00L5B1 WD-WCAU4C700099 -358681974488035005
To Search:
File list (Check if you may need any files):
EpsDiskId
.........\crc64.cpp
.........\crc64.h
.........\diskid.cpp
.........\diskid.h
.........\EpsDiskId.cpp
.........\EpsDiskId.rc
.........\EpsDiskId.sln
.........\EpsDiskId.vcxproj
.........\EpsDiskId.vcxproj.filters
.........\esp_lib.h
.........\Include
.........\.......\sqlncli.h
.........\.......\srv.h
.........\lib
.........\...\x64
.........\...\...\opends60.lib
.........\...\...\sqlncli.lib
.........\...\x86
.........\...\...\opends60.lib
.........\...\...\sqlncli.lib
.........\resource.h
.........\x64
.........\...\Release
.........\...\.......\EpsDiskId.dll
.........\...\.......\EpsDiskId.lib
.........\xp_dblib.cpp
Download