or Create a profile
23 Oct, 2017 11:04 AM
How do I remove/delete an non active group?
on 23 Oct, 2017 11:11 AM
Currently, there's no way to delete a Group short of deleting it directly
from within Microsoft SQL Server Management Studio.
on 23 Oct, 2017 11:16 AM
Ok :( - can you send med a TSQL to remove the group? - I guess the table "group" is not enough? - there is no permissions or projects assigned
on 23 Oct, 2017 11:29 AM
It goes as follows:
delete from [Group] where Name = 'YOUR-GROUP-NAME-HERE'
You can double-check that everything is fine and then replace "rollback"
with "commit" and re-run the script.
on 23 Oct, 2017 11:35 AM
ok thanks - but I see there is a reference in GroupPermissionJunction also?
on 23 Oct, 2017 11:57 AM
There could very well be. In this case,
declare @name nvarchar(200) = 'YOUR-GROUP-NAME-HERE'
delete g from [Group] g inner join GroupPermissionJunction gpj on
gpj.GroupID = g.ID and g.Name = @name
delete from [Group] where Name = @name
on 23 Oct, 2017 12:04 PM
thx will try it
Formatting help /
(switch to plain text)
(switch to Markdown)
You can attach files up to 10MB
If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.
A conversation has been started with the HgLab staff to resolve this discussion.
This discussion is private.
Only you and HgLab support staff can see and reply to it.
This discussion is public. Everyone can see and reply to it.
You can use Command ⌘ instead of Control ^ on Mac
Powered by Tender™.