Know your processor by XP_Instance_RegRead SP in SQL Server 2005/2008

XP_Instance_RegRead could be quite a useful extended storedprocedure which ships with SQL Server 2005/2008.
Sometime it happens that you don’t know which processoryour server is using and you want to know it; however, you don’t have physicalaccess of the server than you can use following T-SQL to know thoseinformation.
EXEC master.dbo.xp_instance_regread
‘HKEY_LOCAL_MACHINE’,
‘HARDWARE\DESCRIPTION\System\CentralProcessor’,
‘ProcessorNameString’;
BTW, I have already written two articles before too with useof this kind of extended stored procedure.
Please note that if the user you are using to access SQLServer, wouldn’t have permission in OS to read registry, you will face an errorrather than result.
Reference: Ritesh Shah

http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles butexamples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com
Ask me any SQL Server related question at my “ASK Profile
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: