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

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

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

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