MSSQL installed features

I am looking for a command simliar to the @@VERSION variable that will tell me features installed in my MSSQL instance (e.g. SSIS/SSRS etc..). Is there a simple way to pull this information through a SQL script

Answers


Many of these features live outside the SQL instance, so they are not query-able. The tool provided is the Features Discovery Report, which is explained in detail in this blog post.


Need Your Help

Fork parent child communication

c fork ipc

I need some way for the parent process to communicate with each child separately.

Django share unpicklable objects between requests

django

I am currently working on a Django project that will hopefully make some transformations to videofiles thru the web. To make the transformation to the videos, I am using opencv's python API and I a...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.