00153453
NoSQLButton (Disabled SQL Query Window) - Trigger Find Script
Older customers of SedonaOffice may have had their SQL Query Window Button disabled from within the application for all users. Despite attempts for an admin to enable the SQL Query Window it would simply untick on Save.
You can use the following Script to locate all triggers (there shouldn't be many)
SELECT
t.name AS TriggerName,
s.name AS SchemaName,
o.name AS TableName
FROM sys.triggers t
JOIN sys.objects o
ON t.parent_id = o.object_id
JOIN sys.schemas s
ON o.schema_id = s.schema_id
WHERE t.parent_class_desc = 'OBJECT_OR_COLUMN'
ORDER BY s.name, o.name, t.name;
You will want to look for a Trigger named NoSQLButton or associated with SY_User_Group_Acc_Detail
