Transact-SQL Naming Issues
When you analyze the Transact-SQL code in your database project, one or more warnings might be categorized as naming issues. You should address naming issues to avoid the following situations:
The name that you specified for an object might conflict with the name of a system object.
The name that you specified will always need to be enclosed in escape characters (in SQL Server, '[' and ']').
The name that you specified might confuse others who try to read and understand your code.
The code might break if you run it with future releases of SQL Server.
In general, you might suppress a naming issue if other applications that you cannot change depend on the current name.
In This Section
Visual Studio Premium identifies the following design issues:
Analyzing Database Code to Improve Code Quality
Describes how you can find common design, performance, and naming issues in your Transact-SQL code.
Transact-SQL Design Issues
Contains links to the different types of design issues that you might find when you analyze your database code.
Transact-SQL Performance Issues
Contains links to the different types of performance issues that you might find when you analyze your database code.
Walkthrough: Analyze Transact-SQL Code for an Existing Database
Describes how you can analyze the AdventureWorks2008 sample database to identify coding issues.
Create and Register Additional Rules for Analyzing Database Code
Describes how you can create your own rules for analyzing database code to look for issues that are not found by the built-in rules.