note 79210 deleted from function.mssql-connect by tularis
| From: | tularis@php.net | Date: | Sun, 13 Apr 2008 12:45:02 +0000 |
| Subject: | note 79210 deleted from function.mssql-connect by tularis | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-138257@lists.php.net to get a copy of this message | ||
Note Submitter: Anonymous
----
SQL Server query to find the port your server is running on:
set nocount on
DECLARE @test varchar(20), @key varchar(100)
if charindex('\',@@servername,0) <>0
begin
set @key = 'SOFTWARE\MICROSOFT\Microsoft SQL Server\'
+@@servicename+'\MSSQLServer\Supersocketnetlib\TCP'
end
else
begin
set @key = 'SOFTWARE\MICROSOFT\MSSQLServer\MSSQLServer\Supersocketnetlib\TCP'
end
EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key=@key,@value_name='Tcpport',@value=@test OUTPUT
SELECT 'Server Name: '+@@servername + ' Port Number:'+convert(varchar(10),@test)