by Administrator | May 7, 2024 | Non classé
Follow this tutorial if you want to make a quick backup of a DeMaSy database(s) with default options: Run DeMaSy Utilities software (see how to Access to DeMaSy Utilities) and log in Click on the Backup icon menu 1 – Select one or more databases on the list in...
by Administrator | Apr 24, 2024 | Non classé
Transparent Data Encryption (TDE) is a method used to encrypt data-at-rest within a database, ensuring that stored data remains encrypted on disk and is only decrypted when accessed by authorized users or applications. So you can safely enable this option on your...
by Frédéric Lamain | Apr 24, 2024 | Non classé
If you want to use interface Excel to import data, you need to make changes in windows. Follow the next steps 1. Login to the server as a administrator.2. Go to “Start” -> “Run” and enter “taskmgr”3. Go to the process tab in task...
by Administrator | Apr 10, 2024 | Non classé
DECLARE @GLAccountSearchStr varchar(30);DECLARE @Date date;Set @GLAccountSearchStr = ‘513’;Set @Date = ’31/12/2023′; Select [LogicalName], [Number], [Currency], [ResMaxDate], Sum(Round([CyResult], 2)) as [CyResult] from (Select...
by Frédéric Lamain | Jan 2, 2024 | Non classé
Declare @DBId int = 34 Delete from [Address] where [DBId] = @DBId;Delete from [Article] where [DBId] = @DBId;Delete from [ArticlePrice] where [DBId] = @DBId;Delete from [ArticleSupplier] where [DBId] = @DBId;Delete from [ArticleType] where [DBId] = @DBId;Delete from...
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...