Salut, cum pot afla seria unica a HDD-ului pe care este instalat SQL Server folosind SQL Server 2005 Express.
Mentionez ca doresc sa aflu Serial Number NU Volume Serial Number.
Pentru Volume Serial Number am reusit folosind urmatoarul cod:
---------
declare @tbl table(dir_lines varchar(200))
declare @Cmd varchar(2000)
set @cmd = 'dir "' + (select name from sys.dm_os_loaded_modules where description like 'SQL Server%' and name like '%sqlservr.exe') + '"'
insert into @tbl
exec xp_cmdshell @cmd
select * from @tbl where dir_lines like '%volume%serial%'
----------
Multumesc anticipat!