Is there a clear and methodological method to change the compatibility mode of a databases individual Tables & Columns? A 3rd party database was upgraded and migrated to SQL 2005, the SQL Server Compatibility is at the correct setting, but there are tables/columns contained within the new db that have retained old compatibility settings.
Sql-server – Changing the SQL Server Compatibility setting for individual tables/columns, which have retained older settings
sql-server-2005
Related Question
- Sql-server – Restore a database to different databases without losing any data
- SQL Server – Most Efficient Way to Get Stats on an Entire Database
- SQL Server – Updating DBO Accounts After Active Directory Shutdown
- Sql-server – the most efficient way to get the minimum of multiple columns on SQL Server 2005
- Sql-server – Upgrading SQL Server 2005 to 2016
Best Answer
Compatibility levels are set at the database, not at the table or column.
You might be thinking of collations, which are set at the column level. You can't simply change the collation on those objects - you have to build new objects with the right collations and push the data into them.
You might also be thinking of deprecated datatypes like text, ntext, image, or vardecimal. You don't have to change those yet, but you'll have to fix them before a future SQL Server version.