I’ve got my hands on a couple of new SQL servers and I would like to set up a replicated instance of NAV. On a different database (which is a reporting DB which accesses the NAV DB amongst other things) I was able to successfully set up replication between the two servers. However, with the Nav instance, we have some indexed views which subsequently fail when I try to connect the client to the replicated (subscriber) database.
The error states ‘Hint noexpand’ on object … is invalid’ for several views.
Has anyone been able to set up a replicated instance of NAV which uses indexed views and got around this problem?
The error message (seem to be unable to upload images):
"The following SQL Server error or errors occured when accessing the Investment Ledger Entry Table:
8171,“42000”,[Microsoft][ODBC SQL Server Driver][SQL Server]Hint ‘noexpand’ on object 'dbo/…Entry$VSIFT$10’is Invalid.
8171,“42000”,[Microsoft][ODBC SQL Server Driver][SQL Server] Statements(s) could not be prepared."
This occurs for quite a few tables/views, not just the Investment Ledger Entry table.
Many thanks in advance.