SQL SERVER – 2005 – Version Information and Additional Information – Extended Stored Procedure xp_msver | Journey to SQL Authority with Pinal Dave

I was glad when I discovered this Extended Stored Procedure myself. I always used different syntax to retrieve server information. Many of information I was looking up using system information of the windows operating system. Syntax: EXEC xp_msver ResultSet: Index Name Internal_Value Character_Value ------ -------------------------------- -------------- ------------------------------------- 1 ProductName NULL Microsoft SQL Server 2 ProductVersion… Continue Reading...

Source: SQL SERVER – 2005 – Version Information and Additional Information – Extended Stored Procedure xp_msver | Journey to SQL Authority with Pinal Dave