by FLO | Nov 29, 2023 | Non classé
SELECT t.name AS table_name ,s.row_count AS row_count JOIN sys.dm_db_partition_stats s ON t.OBJECT_ID = s.OBJECT_ID FROM sys.tables t AND t.type_desc = ‘USER_TABLE’ AND t.name not LIKE...
by FLO | Oct 2, 2023 | Non classé
This article is only useful if you already have correctly set the parameters for the interface currency rate. you can refer to this article : Interface currency rates parameters -Go to to download the file :...
by FLO | Mar 31, 2023 | Non classé
-Check compatibility ( Windows 64bits, Office 64bits, Framework 4.8 ) -Uninstall DeMaSy Service in V10 ( keep the DeMaSy.ini , DeMaSyService.ini and StartStopDeMaSyService.ini files somewhere) -Uninstall Crystal Reports for Workstation -Uninstall Crystal SAP Crystal...
by FLO | Feb 1, 2022 | Non classé
Go to the Task Scheduler Add a new Task Set the task with the following properties You need to create the following .bat file
by FLO | Jul 27, 2021 | Query
Update UserGroup from Group after activation of the new rights Update [UserGroup] Set [UserGroup].[Type] = [Group].[Type], [UserGroup].[DBGroupId] = [Group].[DBGroupId], [UserGroup].[DBId] = [Group].[DBId]From [UserGroup] Inner join [Group] On [UserGroup].[GroupId] =...