Friday, March 6, 2015

How can get SQL Server Startup Parameter path ?

Method 1:
DECLARE  @startup VARCHAR(255)
DECLARE  @arg VARCHAR(10)
DECLARE  @i INT
SET @i = 0
SET @startup = ''
WHILE(@startup IS NOT NULL)
BEGIN
SET @arg = 'SQLArg'+CAST(@i AS VARCHAR(2))
SET @startup = NULL
EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer\Parameters', @arg,  @startup OUTPUT
SELECT @startup
SET @i= @i+1
END
Method 2:
SQL Server configuration Manager > SQL server services >SQL Server(<Instance Name>)>properties >Advanced > Startup Parameters

No comments:

Post a Comment