• sqlfriends (8/28/2014)


    But sometimes those databases need to work with different SQL server versions.

    For example some retired db is at version 2000 and only works with 2000, some with 2005 etc.

    So only one instance cannot meet the requirment.

    In my experience, most of the time the lowest compatibility mode is sufficient. Hardly ever have I had problem unless one is supporting 7.0 or earlier.

    😎