Track who has upgraded a Navsion SQL database

mheijkant

is there an SQL table, property or some kind of info on who has upgraded a database by opening a database with a newer client?

kine

I am afradid that there is no such an info. But the user must have enough permissions on SQL to do that. It means it must be DB_OWNER or SYSADMIN. I assume that there are only few users with this permissions. if not, there is something wrong with your configuration...

dave_c

I'm not 100% what actually happens when a database is upgraded using a newer client but would you be able to find it in the default SQL trace? If it's altering tables that would appear in the trace with a username against the event.

stryk

Just thinking (cannot test now):

There's the table "$ndo$dbproperty" - a NAV system table. Here it's actually the "databaseversionno" which tells NAV which client version is allowed to connect.
In progress of a db conversion ("upgrade") this "databaseversionno" is changed. So maybe you could create a SQL trigger for that table (AFTER INSERT, UPDATE, DELETE) to record any changes here?!