Changed EngineEdition check to include Managed Instance
Fixes # .
Changes proposed in this pull request:
In every check for engine edition I have added both 5 (standalone database) and 8 (managed instance)
Added utility install.sql file that works in sqlcmd mode and executes all install scripts.
How to test this code:
Executed new install sql
Executed the following procedures on tpch database - cstore_GetRowGroups, cstore_GetRowGroupsDetails, cstore_GetDictionaries, cstore_GetFragmentation, cstore_GetAlignment successfully with the following warnings:
Warning: The join order has been enforced because a local join hint is used.
Warning: Null value is eliminated by an aggregate or other SET operation.
Warning: The join order has been enforced because a local join hint is used.
Warning: The join order has been enforced because a local join hint is used.
Warning: The join order has been enforced because a local join hint is used.
Warning: The join order has been enforced because a local join hint is used.
Changed EngineEdition check to include Managed Instance
Fixes # .
Changes proposed in this pull request:
How to test this code:
Warning: The join order has been enforced because a local join hint is used. Warning: Null value is eliminated by an aggregate or other SET operation. Warning: The join order has been enforced because a local join hint is used. Warning: The join order has been enforced because a local join hint is used. Warning: The join order has been enforced because a local join hint is used. Warning: The join order has been enforced because a local join hint is used.
Has been tested on (remove any that don't apply):