Get the SQL Server Information from Query

Some times we need to get the information of the SQL Server where it is installed. Simply we can get the info from Query also

-- Get the version info

select @@version
We have a in-built stored procedure called 'xp_msver' to the Server information.
-- Get the Server Information
exec xp_msver

This is a basic information provided but may be useful to the SQL Server learners .

Good day :-)


Popular posts from this blog

How to hide bootStrap popover when user click(s) outside the popover?

Exporting to excel from a custom class object using C#.NET

Get the Clicked Cell Value and Column Name of GridView in ASP.NET