audit trail Log table to be SQL server DB

Classic Servoy
1

Hi all,

I’m migrating my server and starting all over my log table. Audit trail is a big thing for our company.

Just wanted to know, how can I create the log table (audit trail) to be on my SQL server 2000 instead of the default local log_server/log table? I got it working one time before but i can’t figure it out now. Pleaese help!

Using Servoy 2.2, MS SQL server 2000

2

Hi Sammy,

Try the following:

  1. Create a database for the audit trail.

  2. Edit your server connections in Preferences of Developer or on the Server Admin pages. I suggest renaming the old “log_server” and then creating a new “log_server” connection pointing at your new database. This way you can go back to using the old log server if you have problems.

  3. Restart your Servoy Server to start using the new connection.

3

swingman:
Hi Sammy,

Try the following:

  1. Create a database for the audit trail.

  2. Edit your server connections in Preferences of Developer or on the Server Admin pages. I suggest renaming the old “log_server” and then creating a new “log_server” connection pointing at your new database. This way you can go back to using the old log server if you have problems.

  3. Restart your Servoy Server to start using the new connection.

This works GREAT! thanks!