Welcome to Sign in | Help

Get HDD Serial Number

  •  03-28-2009, 12:08 PM

    Get HDD Serial Number

    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!
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems