SQL Server Mentalist


Home | Pages | Archives


BI SQL # 131 : SQL Server DBA Scripts : SQL Script to find MS SQL Server product level details!

July 1, 2013 7:00 am

Hi Folks,

In this article we are going to cover SQL Script to find MS SQL Server product level details!

In this post we are going to discuss following points:

Problem Statement of SQL Script:

How to find MS SQL Server product level details?

Description of SQL Script:

Below SQL Script helps to find the SQL Server Product level information like ProductName; ProductVersion; Language; Platform; Comments; CompanyName; FileDescription; FileVersion; InternalName; LegalCopyright; LegalTrademarks etc

SQL Script Output Column

image

SQL Script Code

EXEC master..xp_msver

SQL Script Output Screenshot

image

User Level to execute

100

If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog :

Link Resource Website

For More information related to BI World visit my Mentalist Blog

SQL Server Mentalist >> SQL Learning Blog

Business Intelligence Mentalist >> BI World

Infographic Mentalist >> Image worth explaining thousand Words

Microsoft Mentalist >> MVC,ASP.NET, WCF & LinQ

DBA Mentalist >>Advance SQL Server Blog

Microsoft BI Mentalist >> MS BI Development Update

Connect With me on

| FaceBook |Twitter | linkedIn| Google+ | WordPress | RSS |

Posted by Vishal Pawar

Categories: Link, Microsoft SQL Server, MSBI, Optimization, Query, Script, SQL Mentalist, SQL PraRup, SQL Query, SQL Server, Technology,, Vishal Pawar

Tags: , , , , , , , , , , , ,

Leave a Reply



Mobile Site | Full Site


Get a free blog at WordPress.com Theme: WordPress Mobile Edition by Alex King.