Final Support and SQL Server Upgrade

One of the basic business of DBA is updgrading. And there are lots of work about it. Eliminating the discontinued features is one of big issues.

Management Studio Truncates Coloumns That Are Larger Then 8192 Bytes

This is a problem which has no solution with SSMS. You can run your script with sqlcmd, it does not truncate result set columns when set correct parameter.