Link to home
Start Free TrialLog in
Avatar of NateR78
NateR78Flag for United States of America

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
SOLUTION
Avatar of Barry Cunney
Barry Cunney
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Or right-click on the table and choose Script table as - Create to  New Query editor window
Post up the resulting script
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of NateR78

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'

Open in new window

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
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
Avatar of NateR78

ASKER

There are currently no duplicates in the table.
Avatar of NateR78

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.