In addition to this; your email server might restrict or allow emails to specific domains...

Sorry I am not sure what you are asking. The case statement you show has two options - 'replicated' or 'not replicated' so I don't understand when you would like...

My experience is with on premise setups so my comments focus on that.

I think you can create an Availability Group with just one Windows Server however it will limit what...

Firstly I'm only a Junior/mid level DBA so I could be wrong with this.

Secondly I appreciate it's a copy-only backup so perhaps not part of your normal backup strategy.

Your questions...

Create your availability group, configure the listener, add databases. Add as many databases as you need

Application connects using listener name, think of that as your new server name. Connection...

Sorry if I sounded like that.

You didn't at all. I understood what you meant. My "I don't intend to come across as ..." was entirely paranoia about my posts...

Edit: BrainDonor and I replied at the same time.

My original reply was only a reply to Grant's reply.

---Original reply---

Thank you for all your advice. It's really helpful

As you said certificates...

Please see 3787558 below. 3787558 contains this post and some edits.

I intended to edit this post but it showed as a new post instead. User error I think.

• This reply was modified 4 years, 12 months ago by as_1234.

Thanks for your reply. I hadn't thought of the possibility of it being cache related.

I don't know all the details of licensing so my answer might not be relevant in your situation.

I wonder if the reseller is referring to the Microsoft License portal. I...

• This reply was modified 5 years ago by as_1234. Reason: Added "The username for the portal was an email address"

I am not sure if you are planning to use the SA login with your applications or if it was only an example.

The SA account has permissions that your applications...

If I've understood the requirement correctly then I think the following should work?:

update  dbo.MeetingDate  set meetingdate=dateadd(DAY,dayValue-5,getdate())

where dayvalue>=7 and dayvalue<=13

It works on the basis that:

The statement...

Thanks for the additional information. Sorry I can't be sure about the cause of this. I've had similar issues with AG's but not this one.

If you haven't seen it the...

To make my questions easier to follow I have used EX-Listener-02 as the listener name for one of the other AGs.

Also, apologises, as you have covered at least some of...

I haven't used this situation so I can't give you any experience. However in answer to whether the versions are identical, this link https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15 may help you.