This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL
Connect to the SQL Server which server you want find the port then open te query Analyser
Ganesh Pittala,
2008-08-09
This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL
Connect to the SQL Server which server you want find the port then open te query Analyser
use master go CREATE TABLE #GetPort (token varchar(100), value varchar(20)) go DECLARE @inst varchar(200) DECLARE @inst1 varchar(100) IF(charindex('\',@@servername) > 0) BEGIN SELECT @inst = substring(@@servername,charindex('\',@@servername),50) SELECT @inst = 'SOFTWARE\Microsoft\Microsoft SQL Server'+@inst+'\MSSQLServer\SuperSocketNetLib\Tcp' SELECT @inst1 = 'TcpDynamicPorts' END ELSE BEGIN SELECT @inst = 'SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib\Tcp' SELECT @inst1 = 'DefaultPort' END INSERT #GetPort EXEC master..xp_regread 'HKEY_LOCAL_MACHINE',@inst,@inst1 SELECT value FROM #GetPort DROP TABLE #GetPort
2012-03-30
448 reads
SQL 2000 SP4 failure on Cluster with error:Setup failed to perform required operations on the cluster nodes
This is a follow up to the article "Return Query Text Along With sp_who2 Using Dynamic Management Views".
Continuing with his series on Alias Data Types in SQL Server 2000, Yakov Shmalfman brings us part 5, looking at indexes.
2008-04-17
1,161 reads
Script one or all roles in a database. Includes users, obect permissions and column permissions.
2011-09-08 (first published: 2008-01-08)
5,257 reads