How to know whether a computer is a Sql Server according to the name of computer

Thanks a lotremark: in sql statement|||run this query:select srvproduct from dbo.sysservers
if it comes back with 'SQL Server' then you are on SQL Server|||SELECT SERVERPROPERTY('SERVERNAME')
It would return the Instance name. If the output resembles with ur system-name; the SQL is the default instance. Othwerwise it would be a named instance, i.e., like :machine\instance|||such as :
you are on computer A that running a sql server,then you want to konw if computer B is running sql server.|||Download this tool from Microsoft:

http://www.microsoft.com/downloads/details.aspx?FamilyID=9552d43b-04eb-4af9-9e24-6cde4d933600&DisplayLang=en

It contains SQLScan, which will scan the LAN for all SQL Server installations.|||If you have sql server, and you are interested:

select @.@.version

will give you the version information.

:)