Other Technical Tips

QLS related_Optimum

How to repair a 'SUSPECT' Database in Optimum
Some of the reasons why an SQL Server database can be marked as SUSPECT Database could have been corrupted. There is not enough space available for the S...
Fri, 4 Sep, 2020 at 2:04 PM
How to Connect to Database use Microsoft SQL Server Management Studio
Click Start > Search Run > Click Run. Insert SSMS > Click OK. SSMS is Open > look for server instance (normally is 'PC Name'...
Fri, 25 Sep, 2020 at 11:43 AM
Identify your SQL Server Version and Edition
To Identify SQL Server Version and Edition you are running using the Windows Command Prompt, Please follow this simple step  Step 1 : Click Start -->...
Fri, 25 Jun, 2021 at 4:47 PM
After click "Inquiry" on Reports then system show error message "Illegal characters in path." and show blank screen.
  Solution:  This is because of Company Name have put symbol Step 1 - Click on Database Wizard Step 2 - Highlight Database and click on &...
Mon, 7 Sep, 2020 at 2:22 PM
When preview report got error 1131: The type or namespace name 'Datasources' does not exist in the namespace 'QNE.ERP.Reports.Utils'(are you missing an assembly reference)
When preview report got error 1131: The type or namespace name 'Datasources' does not exist in the namespace 'QNE.ERP.Reports.Utils'(are you...
Mon, 7 Sep, 2020 at 3:37 PM
How to Shrink Database Transaction Log
Connect to Database use Microsoft SQL Server Management Studio Start a New Query Copy and Paste the following SQL Script into the New Query Shrink Data...
Fri, 25 Sep, 2020 at 11:45 AM
How to Check and Clear all Opening Balance entry (include duplicated entry)
Financial Period Precaution: Note: Cut off date must be in between financial period. And Financial Period, Cut off date cannot simply change, please mak...
Tue, 8 Sep, 2020 at 11:50 AM
Where can i download the latest copy of user manual for QNE Optimum?
QNE Optimum is a GST compliant software approved by Royal Customs Malaysia, we will try to update our user guide and make it up-to-date , if there is any ne...
Fri, 25 Sep, 2020 at 11:14 AM
Failed to shrink transaction log file size (.ldf)
Step 1 - Connect to Database use Microsoft SQL Server Management Studio. Please refer How to Connect to Database use Microsoft SQL Server Management Studio...
Fri, 25 Sep, 2020 at 11:51 AM
Failed to create clustered index during database upgrade.
Failed to create clustered index during database upgrade. Error as below: Failed to create clustered index. Please try again. Contact our technical suppor...
Tue, 17 Nov, 2020 at 11:40 AM