But if Dynamics NAV is a Microsoft product, they should be smart enough to understand the difference between a snapshot and a real database. It's simple enough for anyone to read sys.databases and see if Source_Database_ID is NULL or not. If that column has a value, it means that the database is a database snapshot.

That's what is confusing me. The fact that it is so simple to tell the difference, yet the application apparently can't.

EDIT: Also, snapshots can't have the same name as the source database. So it has to deliberately be inserting into a database of a different name (the snapshot) to create this problem.