T-SQL Analyzer

# SQL Server Rule: SRN0006 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Naming | | Class | UseTwoPartNames | ## Rule Information | | | |----|----| | Id | SRN0006 | | Friendly Name | Use of default schema | | Category | Naming | | Ignorable | false | | Applicable Types | Default | | | Dml Trigger | | | Procedure | | | Scalar Function | | | Sequence | | | Table | | | Table Type | | | Table Valued Function | | | User Defined Type | | | View | ## Description Two part naming on objects is required. ## Summary Using two part naming on objects [Schema].[Name] is recommended ### Examples ```sql CREATE PROCEDURE CreateProcedureNoSchema AS SET NOCOUNT ON; select Col1 from [dbo].TestTableSSDT RETURN 1 -- SML024, SRN0006 ``` ### Remarks Without specifying the schema in the CREATE script will cause SQL Server to try to assign the correct schema which will default to the current users default schema and may or may not be dbo. _{^{Generated by a tool}}