How to create Script to check the Registry Value?

Question

Post reply

How to create Script to check the Registry Value?

haizad

SSC Rookie

Points: 42
More actions
December 26, 2007 at 12:52 am

#180083

Hi the SQL expert,
I want to check the vulnerability for the new server coming from development to Production. I already create the SQl script to check the vulnerability for each server. But I having problem to check the Registry value. Because if i run as per scriprt below, there are a lot values result will appear.
set nocount on
EXECUTE xp_regenumvalues 'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServer\SQLSERVERAGENT'
Please help me if I want onty the SYSAdminOnly value at this Registry?
Regards
🙂

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

jacob sebastian SSChampion Points: 11822 More actions · Answer 1

One option is to put the results of the SP to a temp table and read the desired value from it.

example:

CREATE TABLE #tmp (Value NVARCHAR(200), Data NVARCHAR(500))

INSERT INTO #tmp EXECUTE xp_regenumvalues 'HKEY_LOCAL_MACHINE',

'SOFTWARE\Microsoft\MSSQLServer\SQLSERVERAGENT'

SELECT * FROM #tmp WHERE Value = 'SysAdminOnly'

DROP TABLE #tmp

But Look at the tutorial given at : http://www.dbazine.com/sql/sql-articles/larsen11

and http://www.dbazine.com/sql/sql-articles/larsen10

.

haizad SSC Rookie Points: 42 More actions · Answer 2

Hi

i got the error:

Msg 515, Level 16, State 2, Server MYMSCAPP115, Line 11

Cannot insert the value NULL into column 'Data', table 'tempdb.dbo.#tmp________________________________________________________________________________________________________________00000032AA6A'; column does not allow nulls. INSERT fails.

The statement has been terminated.

Value

Data

Pls advice

jacob sebastian SSChampion Points: 11822 More actions · Answer 3

Modify the definition of the temp table

CREATE TABLE #tmp (Value NVARCHAR(200), Data NVARCHAR(500) NULL)

.

Jeff Moden SSC Guru Points: 1004407 More actions · Answer 4

These should help...

http://www.databasejournal.com/features/mssql/article.php/1462641

http://codebetter.com/blogs/raymond.lewallen/archive/2005/09/12/131869.aspx

http://www.novicksoftware.com/UDFofWeek/Vol2/T-SQL-UDF-Vol-2-Num-41-udf_Sys_RegReadStr.htm

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

haizad SSC Rookie Points: 42 More actions · Answer 5

hi jacob sebastian & Jeff Moden,

Tq for your support & advice.

If u have other scriprt like to check file system, Local Policy & Registry permission. Please advice me.

TQ

😀

Jeff Moden SSC Guru Points: 1004407 More actions · Answer 6

Nope... that's pretty much it...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)