NateR78
asked on
SQL Server Key Violation? Non-PK Field Getting Errors if Value Not Unique
I'm not sure what I'm missing here, but I have a SQL server database that was converted from an Access database, and if I insert a record onto a certain table, I get errors if any records are created with duplicate data in a "storeNo" field. I'm a bit new to SQL so I'm hoping it's just something I'm overlooking.
The field is not designated as a primary key, and I can't find anything in the field properties that would indicate there could be an issue with having two records with non-unique data in this field.
See the attached screenshot. Ideas?
tblStores.jpg
The field is not designated as a primary key, and I can't find anything in the field properties that would indicate there could be an issue with having two records with non-unique data in this field.
See the attached screenshot. Ideas?
tblStores.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Here is the script for the table:
USE [RAC]
GO
/****** Object: Table [dbo].[tblStores] Script Date: 02/15/2012 10:43:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblStores](
[storeID] [int] IDENTITY(1,1) NOT NULL,
[distID] [int] NULL,
[storeNo] [smallint] NULL,
[clientMatter] [float] NULL,
[storeAddress] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[storeCity] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[storeState] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[storeZip] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[storePhone] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[storeFax] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[storeMgr] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[blnDialOne] [bit] NOT NULL DEFAULT ((0)),
[upsize_ts] [timestamp] NULL,
CONSTRAINT [aaaaatblStores_PK] PRIMARY KEY NONCLUSTERED
(
[storeID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'17' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'storeID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'storeID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowMultipleValues', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowValueListEdits', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_BoundColumn', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnCount', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHeads', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidths', @value=N'0;1440' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ties to tblDistricts' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'111' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_LimitToList', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ListRows', @value=N'16' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ListWidth', @value=N'0twip' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_RowSource', @value=N'SELECT tblDistricts.distID, tblDistricts.distNo + '' ('' + tblDistricts.distID + '')'' AS distNo, tblDistricts.distNo
FROM tblDistricts
ORDER BY tblDistricts.distNo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_RowSourceType', @value=N'Table/View/StoredProc' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'distID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'ShowOnlyRowSourceValues', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'distID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'distID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'1020' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'RAC store number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'storeNo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'storeNo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeNo'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Internal billing number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_InputMask', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'clientMatter' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'clientMatter' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'7' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'clientMatter'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'3090' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Address' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'storeAddress' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'storeAddress' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'storeCity' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'5' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'storeCity' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeCity'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'storeState' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'6' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'storeState' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeState'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'storeZip' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'7' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'storeZip' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeZip'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_InputMask', @value=N'!\(999") "000\-0000;;_' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'storePhone' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'storePhone' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storePhone'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'3825' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'storeFax' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'9' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'storeFax' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeFax'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Name of local store manager' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'storeMgr' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'storeMgr' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'storeMgr'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'CurrencyLCID', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'DefaultValue', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'¿¿¿¿¿¿¿¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'106' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Format', @value=N'True/False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'blnDialOne' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'11' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'ResultType', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'blnDialOne' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores', @level2type=N'COLUMN',@level2name=N'blnDialOne'
GO
EXEC sys.sp_addextendedproperty @name=N'AlternateBackShade', @value=N'95' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'AlternateBackThemeColorIndex', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'AlternateBackTint', @value=N'100' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'BackShade', @value=N'100' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'BackTint', @value=N'100' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'DatasheetForeThemeColorIndex', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'DatasheetGridlinesThemeColorIndex', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'DateCreated', @value=N'12/26/2011 1:25:26 PM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'DisplayViewsOnSharePointSite', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'FilterOnLoad', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'HideNewField', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'LastUpdated', @value=N'1/12/2012 9:01:42 AM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DefaultView', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_LinkChildFields', @value=N'storeID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_LinkMasterFields', @value=N'storeID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_OrderByOn', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Orientation', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SubdatasheetName', @value=N'Table.tblDemands' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'tblStores' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'OrderByOnLoad', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'PublishToWeb', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'ReadOnlyWhenDisconnected', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'RecordCount', @value=N'656' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'ThemeFontIndex', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'TotalsRow', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
GO
EXEC sys.sp_addextendedproperty @name=N'Updatable', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblStores'
Look for a Unique Key constraint or a Unique Index. Probably the latter since it was converted from Access.
Do think twice about removing it, though. It was put there for a reason :>)
Also, very unusual to have a non-clustered index on an identity pk. Another hint, that there may be a unique clustered index on store_no (or the combination of StoreNo + DistID
Do think twice about removing it, though. It was put there for a reason :>)
Also, very unusual to have a non-clustered index on an identity pk. Another hint, that there may be a unique clustered index on store_no (or the combination of StoreNo + DistID
Check if there are already an duplicates in the existing data in the StoreID field
SELECT max(StoreID)
FROM tblStores
GROUP BY StoreID
HAVING COUNT(*) > 1
SELECT max(StoreID)
FROM tblStores
GROUP BY StoreID
HAVING COUNT(*) > 1
ASKER
There are currently no duplicates in the table.
ASKER
I did find the constraint on the storeNo field, and I do think I'm going to leave it there. Will just need to modify my code to compensate for this on the front end. There should never be duplicate store numbers, but I'm getting errors at the outset of a record insert because sometimes two people will create a blank record at the same time. Thanks for all your help, as always!
Good. Logical constraints are your best friend. My guess is that the business does not want a store without a store number, so the front end needs to be aware of that and avoid inserting the record until the store number is known. Or alternatively, you can generate the "next" store number automatically as part of the insert.
Consider the implications if the row gets inserted without a StoreNo and then the process is not completed.
Consider the implications if the row gets inserted without a StoreNo and then the process is not completed.
Post up the resulting script