Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

SQL Server and Azure SQL Database have a property called compatibility level. Microsoft supports compatibility levels back to SQL Server 2008 and has committed to keep those in newer releases of the ...

I've been able to move databases with sp_detach and sp_attach. Obviously, connections to that database will be dropped, but it shouldn't affect any others.