GeoMedia Discussions

Search for an answer, post a question, or answer other users' questions in our GeoMedia support discussions. This discussion board is a great way to collaborate with industry peers around the world. It is intended for discussion and support of the GeoMedia Desktop and Add-on applications.
Showing results for 
Search instead for 
Do you mean 
Senior Member
Posts: 1
Registered: ‎12-01-2015
Accepted Solution

Microsoft SQL server triger



I use microsoft sql server and  create "on insert triger" on feature class, this triger insert data in second feature class. Insert work correctly, insert what I wish, but i could not see inserted data in second feature class until I close coresponding warehouse and open it again.


I knew that some modification must be done with trigers on geomedia metadata tables but I dont knew what exatly I must do.

It is something similar like "Create Modification log Triger" for Oracle warehouse in "Database Utility" tool.


Can anyone help me?


Best regards


Posts: 156
Registered: ‎05-26-2016

Re: Microsoft SQL server triger

The information you require is in the GeoMedia Help. Look in section Using SQL Server (or Server Spatial) Connections - GeoMedia Metadata requirements.  Here you will find sample of Modification Log Triggers.


Posts: 38
Registered: ‎12-14-2016

Re: Microsoft SQL server triger



Attached you can find an SQL-Script creating ModificationLog Triggers for all tables in your database.