SQL

Symptom  When attempting an archive or purge your database, you see one of the following errors:            When observed in System Administration, you see the following connection error:      Resolution  In most cases, the issue is resolved b...

Symptom In the log, you may encounter errors referring to duplicate serial numbers. The following example is for an Oracle database: Database error encountered: Serial Number: 1360725739, Event: 0-0, Panel: 5281: ORA-0001; unique constraint (LEN...

How to capture a SQL Profiler trace, and then export the results. Procedure Steps Log into SQL Management Studio and select Tools > SQL Server Profiler .   Log into the SQL Server database as a user with permission to perform a trace. Select t...

Symptom  SQL Server Data Source drivers used with OnGuard  Resolution  OnGuard 7.3 and earlier installed with SQL Server requires that SQL Server Data Sources use the SQL Server Native Client 11.0 driver . OnGuard 7.4 and later installed with SQ...

Migrating an Existing SQL Database to Azure SQL   Procedure Steps It is not possible to use the MDF files when migrating an existing OnGuard SQL database into Azure SQL.        Options for migrating an existing OnGuard database into Azure SQL...

Symptom When attempting to open OnGuard applications on the server and workstations, users will receive "Cannot establish communication with the login driver" and when opening SQL Server Management Studio users will see "Package 'Microsoft SQL ...

There is option to increase timeout count on database connection in ACS.ini file.   Procedure Steps 1.      Back up your acs.ini 2.      Run notepad as administrator 3.      Open acs.ini 4.      Add these settings [DataBa...

There are some cases where configuring ODBC logging might provide additional information to troubleshoot application connections that use ODBC.   Procedure Steps Open 32 bit ODBC Data Source Administrator (C:\Windows\Syswow64\odbcad32.exe)...

How to schedule a backup for SQL Server 2005 Express Procedure Steps To back up an SQL Server database on a time schedule for an SQL Server 2017 Express system: 1) Create a folder named SQLBackup in the C:\ drive. 2) Copy the ...

Improving indexes and providing a performance increase when running reports   Procedure Steps   The first 3 SQL commands provide the most improvement. The other 2 are also necessary for overall improvement. If you have any questions, pleas...