In order to find the SQL server name that is used with the BlackBerry, you can use a simple select statement.There are two ways to find the name.
–When both the Windows server and instance information associated with a specified instance of SQL Server are the same use the following code. Under the new query tab type
"SELECT SERVERPROPERTY(‘ServerName’) AS ServerName
—If you are working on a stand-alone instance of SQL Server, use the following SQL statement because this value remains constant and returns the same value as the MachineName property.
"Select SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) asPhysicalName
For more examples of SQL code see: SQL Select Statement: Syntax & Examples