So you've tried setting the DB level compatibility mode back to 110? (2012)?

I gather you've come across this link already then ?

https://support.microsoft.com/en-au/help/3212023/performance-degradation-when-you-upgrade-from-database-compatibility-l

Better late than never 🙂

http://www.sqlscripter.com/Pages/Download.html

Ha, no probs. I'll respond back in 7 years with my findings...

Happen to sort this? I'm getting this exact problem.....

100% of DEV, TEST, UAT and PROD servers. (about 50 of them).Mission critical running under VMware HA.

doesnt work.....

I agree I do not think it is practical to add dummy columns and chaneg the metadata structure of your database just to stop people from writing "select *". How...

your'e a legend Duane (pipe).

G

i agree it was out of place but sometims its nice to highlight the greater scope of a company (and their philosophies). Bills' philanthropy would edge me towards his product(s)...