I appreciate my question is vague.

Perhaps people could give me some examples of Cloud hosted SQL server accesses by local Windows applications that works for them ?

Thanks for the reply
I'm afraid I don't have enough knowledge to be able to answer that beyond saying it's a busy CRM system and response time is important and...

Thanks for the links

Just so I don't misunderstand this does it definitely apply to sp_cursorprepexec ?

The reason I ask is are these calls not 'one-off' queries i.e....

Yes that is what I did

What is parameter sniffing ?

Yes the query is the same in both instances 
It's just a cut and paste from the profiler and obviously replacing the params with the actual values
In SSMS it...

Thanks
So you are saying it does not matter much where in the query the access to sysfile goes it's going to get a shared lock on it that will...

Ref point 1B is this what you mean ?

I guess the type of search we are doing is something akin (on a much much smaller scale) to what google MAPS might do when looking for words in the...

Thanks all
I just wanted to make sure I was not missing a face palm !
It's not an option for us but I guess the only other option is...

Thanks for the prompt reply
Please can you explain the best way to do/try this ?

Line 2 🙂
Joking aside it wasn't initially but then I started it and rebooted the system, checked it was running but it made no difference

I'm not at the system today and wont be again until next Wednesday
But I can tell you that the server properties > connections has the box ticked to allow remote...

Thanks
"The named pipes and TCP/IP is enabled in the configuration manager"

It's a timeout error
What I really don't understand is if SSMS connects fine and the wizard is started from within it why wont the Wizard