Transact-SQL Design Issues
When you analyze the Transact-SQL code in your database project, one or more warnings might be categorized as design issues. You should address design issues to avoid the following situations:
Subsequent changes to your database might break applications that depend on it.
The code might not produce the expected result.
The code might break if you run it with future releases of SQL Server.
In general, you should not suppress a design issue because it might break your application, either now or in the future.
Visual Studio Premium identifies the following design issues: