Home → Problems →

delete "group"

• Edit

felix.nielsen

Oct 23, 2017 @ 11:04 AM

Hi

How do I remove/delete an non active group?

Thanks

1. Support Staff 1 Posted by Anton Gogolev on Oct 23, 2017 @ 11:11 AM

   

   Felix,

   Currently, there's no way to delete a Group short of deleting it directly
   from within Microsoft SQL Server Management Studio.

   • Edit

2. 2 Posted by felix.nielsen on Oct 23, 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

   Felix

   • Edit

3. Support Staff 3 Posted by Anton Gogolev on Oct 23, 2017 @ 11:29 AM

   

   Felix,

   It goes as follows:

   begin tran
   delete from [Group] where Name = 'YOUR-GROUP-NAME-HERE'
   rollback tran

   You can double-check that everything is fine and then replace "rollback"
   with "commit" and re-run the script.

   • Edit

4. 4 Posted by felix.nielsen on Oct 23, 2017 @ 11:35 AM

   

   ok thanks - but I see there is a reference in GroupPermissionJunction also?

   • Edit

5. Support Staff 5 Posted by Anton Gogolev on Oct 23, 2017 @ 11:57 AM

   

   Felix,

   There could very well be. In this case,

   declare @name nvarchar(200) = 'YOUR-GROUP-NAME-HERE'

   begin tran
   delete g from [Group] g inner join GroupPermissionJunction gpj on
   gpj.GroupID = g.ID and g.Name = @name
   delete from [Group] where Name = @name
   rollback tran

   • Edit

6. 6 Posted by felix.nielsen on Oct 23, 2017 @ 12:04 PM

   

   thx will try it

   • Edit