May 5, 2014 at 12:58 pm
Assume if i have a connection(Application intent readonly) starts with reading, writing and again reading data for a report. how it will works in SQL 2014 Always availability on?
May 6, 2014 at 6:56 am
mxy (5/5/2014)
Assume if i have a connection(Application intent readonly) starts with reading, writing and again reading data for a report. how it will works in SQL 2014 Always availability on?
With application intent = read only it will only read!
What scenario are you trying to describe?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 6, 2014 at 7:37 am
assume a data load starts with select then insert and display results at the end,
May 6, 2014 at 8:43 am
then your application intent is not readonly is it 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply