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
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
Note: Microsoft Books online is a default reference of all articles butexamples and explanations prepared by Ritesh Shah, founder of
Ask me any SQL Server related question at my “ASK Profile

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: