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