Monday, April 18, 2011

How to find SQL Server information

Run the extended procedure to get sql server internal information
xp_msver



You can use parameter to get specific information
xp_msver 'ProductName', 'ProductVersion', 'Language', 'Platform', 'WindowsVersion', 'PhysicalMemory', 'ProcessorCount'