Summary

You can set a SQL Server login as the owner of the database tables associated with your Laserfiche repository. However, this can prevent you from moving documents and configuring auditing.

Cause

Currently, Laserfiche expects the owner of the AuditEvent table to be "dbo". If the table's owner is another database user, then you may encounter an Error 7050 when moving entries or configuring auditing.

Workaround

Set "dbo" as the owner of the AuditEvent table.

To change the owner of a database object using osql

1. Click Start and then click Run.
2. Type the following and click OK to load a command prompt:

   cmd

3. Type the following to load osql:

   osql -E -S ComputerName\Laserfiiche

   Note: If you are using the full version of Microsoft SQL Server, then you should only specify the name of the computer where the SQL Server resides.

4. Type the following to change the owner of the AuditEvent table for your database:

   USE YourDatabaseName
   EXEC sp_changeobjectowner 'CurrentOwner.AuditEvent', 'dbo'
   GO