You are welcome

As for the application connection - this often falls to how that connection information is cached on the application server and how the connection string is built.

As for the listener...

Let's start with the login/user issue...

Logins are created at the server level - and users are created in the database.  SQL Server know that login ABC is the same as...

I would recommend adding either a disk or file share to the 3-node cluster giving (by default) 4 votes.  Then - I would set the node weight of the 3rd...

You can use a CTE or CROSS APPLY:

CTE Version:

  WITH ageDetail
    AS (
SELECT Birthdate
     , CurrentDate = getdate()
 ...

Thanks for all the idea, first time I read about CREATE SYNONYM (I suck at this sometimes!!... lol)

I'm going to learn about this and start applying it ...

The problem...

Looking at this again - is the issue you are having related to the file(s) having a header/trailer record and detail records?  If so - that can be handled in...

What is the issue you are facing?  What have you tried so far - and where is it failing or causing issues?

• This reply was modified 6 years, 3 months ago by Jeffrey Williams.

I am not sure how a 'table' change requires updating/modifying all stored procedures/views/functions/etc...  Do you mean to say that the old table is no longer used - and a new...

If you want reporting to be available in that situation - you would need an additional secondary in the DR location to support that requirement.  However, in a disaster scenario...

Because the database is part of an AG - make sure you check the send and redo queues.  To see that - view the availability group dashboard by right-clicking on...

My next question would be - is the requirement for near real-time reporting data actually needed?  In almost every case I have dealt with - the reality was that the...

What is the purpose of mirroring the database?  In a normal mirror - the database is not accessible.  To get a read-only version of a mirrored database you have to...

You don't delete the users on the secondary - users are part of the database and since that database is not accessible you cannot make any changes to the users. ...

Logins are created at the server level - and users are added at the database.  To have the logins on the secondary server tie to the users in the database...