(248) 478-2555 | sales@savance.com | Live Chat
Free DemoContact | Partner Signup |Support |
  1. Home
  2. Knowledge Base
  3. On-premise/Customer-Hosted Server
  4. SQL

SQL

Stored procedure can only be executed at the ad hoc level

This article applies if you are receiving the following error when upgrading your EIOBoard database: “Stored procedure ‘sys.sp_dbcmptlevel’ can only...

Manually Upgrade the Database

Make a Backup When making any changes to the database, you will want to make a backup so that you...

Create Database Failed Error

The error “CREATE DATABASE failed.” is an error that takes place when installing the EIOBoard server. Even though the error...

Configure SQL Server to send notification upon failure

Sometimes SQL server service tends to stop or fail due to many factors, such as Operating system issues, HardDisk issues,...

Assigning an Administrator Privilege to a User From the Server

You must have full access to the server or SQL database to do this task.  You need to open up...

Resolve issue with Log file filling up the drive

Sometimes a SQL server database has its recovery mode set to Full mode, and without taking a backup, the log...

SQL Collation Conflict When Installing Workplace

When installing Workplace, it’s possible that you may run into a SQL error similar to this one: “Cannot resolve collation...

On-Prem only – Remove or Modify the Comment (Nightly Status Update) that shows up when users are automatically signed out at midnight

This article applies only to customers who have an on premise aka customer hosted installation of Workplace. Some of our...

Exporting and Importing Users From One Database to Another

In some instances, data from one Workplace database may need to be merged into another new or existing Workplace database....

Execute with Results Failed for Database Error

The error “Execute with results failed for database _______” is caused when the SQL credentials are for a user with...

Changing Minimum Password and Username Length Requirements

Recently, Savance Workplace underwent a security update that raised the default minimum length for usernames and passwords to 8 characters....

Azure Data Studio: Execution Failed Due to an Unexpected Error: Position is Outside of File Line Range (Parameter ‘line’)””

The manual upgrade script will fail when running the Workplace manual SQL upgrade script from Azure Data Studio. Azure Data...

How to Back up the Savance Workplace Database

If you’re migrating your server you’ll need to create the backup file to move to the new server. It is...

What database backend does Workplace run on?

Workplace MSQL Workplace uses a Microsoft SQL Server backend (MSSQL). This provides increased security and scalability over products that use...

My Workplace will not connect or establish connection to the database?

Workplace tries to make a connection to the database to make sure you are running the latest version. If your...

How to Remove Future Statuses from Workplace

If you have added Future Statuses to Workplace (such as through Outlook Sync. or Exchange Sync.), Workplace is not currently...

How do I Restore a Workplace Backup Database?

To restore a Workplace backup database, the first thing you want to do is to locate your database backup file...

How to Find my Database Backup Location

Open Workplace Server Administrator Console on your Workplace Server Go to the SQL Tasks tab. Double-click on the “Backup Database”...

SQL Server 2016 Compatibility Issues With V11.8+

Please note SQL Express 2016 is no longer supported with v11.8 or higher due to compatibility issues. You must upgrade...

Renaming or Changing Your SQL Database For On-Premises Customers

When renaming your SQL Database Server, Database name, or replacing your SQL Connection Account, you must update it in 2...
Next

Need Support?

Can't find the answer you're looking for?
Contact Support