InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 23:51:07 GMT20http://www.sqlservercentral.com/Forums/Topic919701-145-1.aspxDear Sirs,Thanks a lot to all. I shall try it and update you.RegardsRajuWed, 12 May 2010 06:21:33 GMTSarikonda Kunam Rajuhttp://www.sqlservercentral.com/Forums/Topic919701-145-1.aspx[quote]with that in mind, here is how you would use xp_cmdshell to call the program and get it's results in a table...you'd then need to parse the results.[code="sql"]create table #Results (TheOutput varchar(1000))insert into #Results (TheOutput)exec master..xp_cmdshell 'echoid -d'select * from #Results[/code][/quote]Wow!! I wonder how many years away I am from that. It sure is one small step at a time. Thanks a lot.- arjunWed, 12 May 2010 06:14:32 GMTArjun Sivadasanhttp://www.sqlservercentral.com/Forums/Topic919701-145-1.aspxnever heard of this locking code before today. it looks like a calculated value created by the program ecoid.exe.the program echoid.exe is not a Windows included executable, so of course it does not exist on all machines; you could only use it if it is installed, and also that the program exists int he PATH variables on the server...also note that the page you directed us to requires a .dat file to be in place as well.[quote]Tip: The file echoid.dat must be in the same directory as the echoid program file. This file defines what criteria will make up the fingerprint and is shipped along with echoid.exe.[/quote]with that in mind, here is how you would use xp_cmdshell to call the program and get it's results in a table...you'd then need to parse the results.[code]create table #Results (TheOutput varchar(1000))insert into #Results (TheOutput)exec master..xp_cmdshell 'echoid -d'select * from #Results[/code]and my results:[code]'echoid' is not recognized as an internal or external command,operable program or batch file.NULL[/code]Wed, 12 May 2010 06:08:48 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic919701-145-1.aspxWell it sounds greek to me Raju. Someone who has better exposure will help you soon. Stick around.- arjunWed, 12 May 2010 05:02:23 GMTArjun Sivadasanhttp://www.sqlservercentral.com/Forums/Topic919701-145-1.aspxSir,Sorry for the confusion if my posting was not clear.Every computer ( here I am looking at Sql Server) will have a locking code unique. I would like to know is there a way to find the locking code of sql server ( physical server) locking code information through a script.You may visit the sitehttp://www.quantumwise.com/documents/manuals/Sentinel_RMS/man_files/echoid_and_Wechoid_-_Get_a_Computer_s_Locking_Code.htmThanks again for the pains taken.ThanksRajuWed, 12 May 2010 04:17:11 GMTSarikonda Kunam Rajuhttp://www.sqlservercentral.com/Forums/Topic919701-145-1.aspxDo you mean version? Please be more specific in your questions. Otherwise you will find that your questions remain unanswered for a long time.If you mean version, use the following query.select serverproperty('productversion')-arjunWed, 12 May 2010 03:52:49 GMTArjun Sivadasanhttp://www.sqlservercentral.com/Forums/Topic919701-145-1.aspxDear Sir, I need a script to find Sql Server Physical Machine Serial. I will be thank ful to the suggession. This is Sql Server 2005. Thanks and RegardsRajuTue, 11 May 2010 07:59:52 GMTSarikonda Kunam Raju