SQL to delete printserver

Information on how to configure Equitrac Office/Express
Post Reply
administrator
Site Admin
Posts: 82
Joined: Mon Dec 03, 2018 10:35 am

SQL to delete printserver

Post by administrator » Sun Feb 02, 2020 6:23 pm

SQL script to remove printserver (DRE) from configuration.
Be carefull using this script, Ewouds.com is not responsible for wrong usage.

-- Equitrac
DECLARE @eqservername nvarchar(100)
SET @eqservername = 'HASRV' -- change the text between the single quotes with the name of the server

-- do NOT modify below this line
DELETE FROM dbo.cas_installedsoftware WHERE systemname = @eqservername
DELETE FROM dbo.cat_site WHERE name = @eqservername
UPDATE dbo.cas_user_ext SET potentialdre = CAST(REPLACE(CAST(potentialdre as nvarchar(max)),@eqservername,'') as NTEXT )

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest