Sunday, December 8, 2013

To get the complete version of SQL Server

To get the complete version of SQL Server

You can use the command below in a new query window of SQL Server.

select @@VERSION

Alternate commands:
SELECT
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel


To get the dll from the GAC(Global Assembly Cache)

To get the dll from the GAC(Global Assembly Cache)

For Pre-defined assemblies, type the below command in Run prompt

%windir%\assembly\gac

For the custom(user) dll

%windir%\assembly\GAC_MSIL