I have a SQL Server database within my Azure tenant, but I’ve been unable to edit any Stored Procedures – or view the list of procs.
The message I get is “unknown property IsNativelyCompiled”.
There are procs in there – I can execute then, or see view via SP_HELPTEXT – but not within Enterprise Manager (Management Studio).
This is within SQL Server 2014 (Management Studio – just the client tools on my Win8.1 PC)
It turns out there’s a SP1 for SQL2014 – which also updates the client tools.
Unfortunately, the SP1 has been pulled – doh. (At time of writing).
For now, I’ve installed SQL 2014 CU6 – which is 640MB !
I can now view the list of Stored Procedures – and edit/update – phew !