Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Read Registry Key

Status
Not open for further replies.
Maii

Maii

Programmer
Aug 28, 2003
54
BD
Hi,
Is there any function to read registry Key in SQL 2K?

Thanks
Maii
 
Sort by date Sort by votes
example below:

Code: 
DECLARE @NodeName varchar(30)
EXEC master.dbo.xp_regread 
'HKEY_LOCAL_MACHINE',  
'SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName',   
'ComputerName',
@NodeName OUTPUT
select 'The active node is ' + @NodeName
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Conditional Foreign Key Constraint
Replies
1
Views
439
Chris Miller
Chris Miller
BTrees
  • Locked
  • Question
Incremental Load (No primary key) 2
Replies
2
Views
371
Olaf Doschke
Olaf Doschke
craigward
  • Locked
  • Question
Cross table insert duplicate key issue 1
Replies
7
Views
390
Olaf Doschke
Olaf Doschke
airwolf09
  • Locked
  • Question
2012 MS SQL SERVER MANAGEMENT STUDIO - Read from txt
Replies
1
Views
165
Olaf Doschke
Olaf Doschke
JoPaBC
  • Locked
  • Question
Incorrect syntax near the keyword 'GROUP' 1
Replies
2
Views
745
JoPaBC
JoPaBC

Part and Inventory Search

Sponsor

Back
Top