Issue
Which SQL query can be used to identify the database layout being used?
Environment
Vista 5.1.X log database
Cause
With the release of Vista 5.1.7 came a new logdatabase layout which is designed to improve performance especially in the area of trend and event log management. This means that there are now 2 possible logdatabase configurations. It can be important to know which version is being used before running any queries or accessing the external log data with external tools.
Resolution
The following query will return the database layout version when run in SQL management studio:
select taclogdata.dbo.DSS_SchemaVersion()
More information can be found in the Vista 5.1.7 release notes.
