Other Technical Tips

QLS related_Optimum

SQL Server Instance installation or update prompted Attempted to perform an unauthorized operation
  Scenario  Performing SQL Server Installation or Update SQL Server version prompted “Attempted to perform an unauthorized operation” ...
Tue, 27 Jul, 2021 at 3:53 PM
SQL Server detected a logical consistency-based I/O error: incorrect checksum
  Scenario  The error of “SQL Server detected a logical consistency-based I/O error: incorrect checksum” might occur when you Insertin...
Tue, 3 Aug, 2021 at 4:53 PM
Database in Single User mode
  Scenario  Unable to login more than 1 user and found that database is in Single User mode Solution  Method 1: Con...
Wed, 21 Jul, 2021 at 8:31 AM
Failed to drop primary key
Scenario  Upgrade Database encountered error ‘Failed to drop primary key …’ The table and foreign key constraint that causing this error coul...
Mon, 2 Aug, 2021 at 3:41 PM
How to Configure Database Path (Video)
Scenario  Accounting Software - Configure Database Path Solution  Please refer the video  https://www.youtube.com/watch?v=OpCbCZUUDvo&list=PLC...
Wed, 15 Sep, 2021 at 9:53 AM
likely culprit is 'IMPORT' when preview
Scenario  Preview transaction or report prompted 0:  Internal Compiler Error (0xc0000006 at address 738D40A1): likely culprit is 'IMPORT'. 0:...
Mon, 6 Sep, 2021 at 1:03 PM
Inquiry screen is blank
Scenario  Inquiry screen is blank and don’t even have column Most properly you have hidden all columns or someone else with your login info has remove...
Mon, 6 Sep, 2021 at 1:13 PM
Error Parsing after launch accounting software - QNE Optimum
Scenario  Encountered Error Parsing when launching QNE Optimum application. This is most likely some Windows files or .Net framework files not working...
Fri, 8 Oct, 2021 at 8:35 AM
Registration Error in Optimum
Scenario  Registration Error prompted when register new database or perform update license in Optimum version 2019 and lower If you are on Optimum ver...
Wed, 16 Feb, 2022 at 2:52 PM
Release free space of database
Scenario  How to release free space in database? SQL Database file are like a box container that constantly grow bigger to store your data but it does n...
Tue, 28 Sep, 2021 at 5:09 PM