Click or drag to resize
sqx

How To Install

Download SQX

SQX Instalation Instructions

NOTE: sysadmin privilege is needed to install SQX..

The following SQL Server configuration will be changed to run SQX.

SQL
Copy
USE master
GO
sp_configure 'show advanced options', 1
sp_configure 'clr enabled', 1
sp_configure 'clr strict security', 0 -- After instalation 1. Can be 0
RECONFIGURE
GO

A note on clr strict security: When clr strict security change from 0 to 1 all clr dac's will be force to reinitialize and this can cause running queries to abort. Care should be taken on production environment.

Standalone Database (Command Prompt)

  1. First step

    SqlPackage Instalation. (Not required)

    dotnet add package Microsoft.SqlServer.DACFx

  2. Second step

    SqlPackage.exe /Action:Publish /SourceFile:".\SQX.dacpac" /TargetDatabaseName:SQX /TargetServerName:"localhost"

Standalone Database (SSMS)

  1. First step

    Create a database SQX (Recovery model simple).

  2. Second step

    In Tasks Menu: Upgrade data tier application.

Removing SQX.

  • SQL
    Copy
    USE master
GO
DROP DATABASE IF EXISTS SQX
DECLARE @sqxdescription nvarchar(4000), @sqxass binary(64);
SELECT TOP 1 @sqxdescription = [description] FROM sys.trusted_assemblies WHERE [description] like N'sqx,%'
IF EXISTS (SELECT 1 FROM sys.trusted_assemblies WHERE [description] = @sqxdescription)
BEGIN
SELECT TOP 1 @sqxass = [hash] FROM sys.trusted_assemblies WHERE [description] = @sqxdescription
EXEC sp_drop_trusted_assembly @hash = @sqxass
END
GO