syscolumns is going away

Remove deprecated system tables in SQL Server 2012

As part of a cleanup we’re looking at our 2012 servers for any DEPRECATION_FINAL_SUPPORT events (via Trace), and came across several caused by SQL Prompt (

syscolumns will be removed in the next version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it.

Yes, SQL Prompt works on 2012, but we’re having to filter them from our logs. If you guys could look at changing that code to use sys.tables (and the like) when querying 2012 servers, we’d greatly appreciate it.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.