Script to find text datatypes in SQL Server
I have a few thousand tables in my SQL Server instance, and I need to start converted old deprecated datatypes into the new version (text to varchar(max)). Is it possible to script this out so I can just run select statement to find all of these without manually going through each of the tables in the database instance? TIA
Script to find text datatypes in SQL Server
===

I have a few thousand tables in my SQL Server instance, and I need to start converted old deprecated datatypes into the new version (text to varchar(max)). Is it possible to script this out so I can just run select statement to find all of these without manually going through each of the tables in the database instance? TIA