February 14, 2011 at 10:22 am
I've been out for the day :Whistling:
Anyway, any rollback statement will undo your whole transaction (including the original inserts and other stuff in the same transaction scope), so be careful with that.
If for any reason you are unable to use the single insert statement as provided in the previous replies, you would need a cursor or while loop :sick: to walk through all rows of the set residing in the "inserted" object.
btw, in your code you specified null for some columns with the insert statement. Removing these columns from your statement will have default values inserted if bound for the columns. Better just double check.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 14, 2011 at 10:25 am
Thank you again ALZDBA. Sean in fact reconstructed my INSERT to exclude the NULLS. It's working great. Now - time to start testing it out for real!
Thanks again!
February 15, 2011 at 7:36 am
OK - came across an interesting issue. Bare in mind that this is SQL 2005 SP3 that I am developing for, so I do not know if this issue is related to the TIMEDATE data type being limited to .10 of a second, but I am getting the following error when trying to INSERT data into one of my tables with the trigger enabled. Here is some of the code I am inserting (the column has a default constraint of GETDATE() on it, but you will see that the datetime going in is not being generated by that default)...
SET NOCOUNT ON
GO
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (1,1,'2/5/2011 10:25:05 AM','Station Pump Alert Station: 5','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (1,1,'2/5/2011 10:26:17 AM','Station Pump Alert Station: 5','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (1,1,'2/5/2011 10:28:31 AM','Station Pump Alert Station: 5','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (1,1,'2/5/2011 10:28:56 AM','Station Pump Alert Station: 5','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (1,1,'2/5/2011 10:29:42 AM','Station Pump Alert Station: 5','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (1,1,'2/10/2011 4:31:10 PM','Station Pump Alert Station: 1','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (1,1,'2/10/2011 4:57:24 PM','Station Pump Alert Station: 1','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (1,1,'2/10/2011 4:57:31 PM','Station Pump Alert Station: 1','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (1,1,'2/10/2011 4:59:07 PM','Station Pump Alert Station: 1','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (1,1,'2/10/2011 4:59:17 PM','Station Pump Alert Station: 1','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/10/2011 7:48:57 AM','Station Scale Alert Station: 8','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/10/2011 7:56:32 AM','Station Scale Alert Station: 8','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/10/2011 7:58:38 AM','Station Scale Alert Station: 8','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/10/2011 8:00:48 AM','Station Scale Alert Station: 8','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/10/2011 8:11:34 AM','Station Scale Alert Station: 8','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/10/2011 10:11:33 AM','Station Scale Alert Station: 8','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/10/2011 10:26:40 AM','Station Scale Alert Station: 6','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/10/2011 10:26:41 AM','Station Scale Alert Station: 8','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/10/2011 10:43:20 AM','Station Scale Alert Station: 3','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/11/2011 11:58:42 AM','Station Scale Alert Station: 1','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/11/2011 11:58:43 AM','Station Scale Alert Station: 2','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/11/2011 11:58:44 AM','Station Scale Alert Station: 3','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/11/2011 11:58:45 AM','Station Scale Alert Station: 4','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/11/2011 11:58:46 AM','Station Scale Alert Station: 5','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/11/2011 11:58:47 AM','Station Scale Alert Station: 6','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/11/2011 11:58:48 AM','Station Scale Alert Station: 7','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/11/2011 11:58:49 AM','Station Scale Alert Station: 8','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/12/2011 3:14:39 PM','Station Scale Alert Station: 1','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/12/2011 4:22:55 PM','Station Scale Alert Station: 1','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/12/2011 4:45:52 PM','Station Scale Alert Station: 4','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (2,1,'2/12/2011 4:46:08 PM','Station Scale Alert Station: 4','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:11:57 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:13:02 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:14:24 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:14:41 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:14:52 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:15:26 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:24:38 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:25:07 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:26:16 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:28:31 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:28:55 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:29:41 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:29:53 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:30:56 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:32:34 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:34:15 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 10:48:25 AM','Seed Wheel Motor Alert','High')
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
VALUES (3,1,'2/5/2011 2:05:41 PM','Seed Wheel Motor Alert','High')
Here is the error...
Msg 2627, Level 14, State 1, Procedure Trg_AlertLogCommand, Line 8
Violation of PRIMARY KEY constraint 'PK_Command'. Cannot insert duplicate key in object 'dbo.Command'.
Now - the PRIMARY KEY is a compound key of the first 3 columns. As you will see from the INSERTS, the COLUMN called "DTRaised" is the TIMEDATE column, and the values there are unique. So - this error is perplexing to me. The Trigger is enabled on this tabled (dbo.AlertLog), and the thought here as Sean and ALZDBA has referenced, is to go with code that would handle a situation like this (so that the trigger could handle multiple INSERTS and not crash, but...)
Any ideas? Many thanks!
February 15, 2011 at 7:44 am
Do you have similair triggers on other tables? I have noticed that you have mentioned this trigger in relation to at least 3 tables throughout this thread.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 15, 2011 at 8:01 am
Hi Sean!
Yes - the trigger code is on 4 tables total, but this is the one where it is erroring out. The only way I have successfully be able to INSERT some sample data into this database has been by deleting the triggers, INSERTING the data, and then reinstalling the triggers after the data is in.
I thought this code re-write was to ensure that multiple INSERTS would work if they were needed. Did I construct the trigger incorrectly? Here is the code used to develop it...
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[Trg_AlertLogCommand]'))
DROP TRIGGER [dbo].[Trg_AlertLogCommand]
GO
--Create Trigger
CREATE TRIGGER Trg_AlertLogCommand
ON dbo.AlertLog
AFTER INSERT
AS
BEGIN
--Creates new Command table record when a row instert takes place on the Priming table. ~RWY 2/14/2011
INSERT INTO dbo.Command ([Requested],[TableID],[RecordID],[Command],[RetriesAttempted],[Cancelled])
SELECT DTRaised, '1', TreaterID, '0', '0', 'False'
FROM inserted
WHERE DTRaised IS NOT NULL
END
Thanks again Sean for any and all help here!
February 15, 2011 at 8:15 am
OK that's what I thought. The problem is not really with the trigger itself. You are inserting into a table of records that can be inserted into from any of a number of tables via triggers. As a result you are getting primary key violations on the new table (Command). There could be any of a number of reasons this is happening. Maybe one of your hardcoded key elements is the same for two of your triggers. Before anybody will be help much further you will need to post some table definitions, triggers code etc for all the tables involved here.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 15, 2011 at 8:43 am
OK - let me see if I can do this without revealing too much. This is a top secret project (seriously - not that I would have to kill you, but I'll get killed if I reveal too much!). :w00t:
I need to reconstruct this - carefully. Will post more later.
February 15, 2011 at 9:06 am
There seems to be some key issues. You are using portions of other fields to make up one part of your composite key.
cast(TreaterID as varchar(5)) + '-' + cast(BatchID as varchar(5))
This is going to haunt you for the life of this system. What is going to happen when your TreaterID or BatchID is longer than 5 characters? You will be bringing this primary key violation right back up again.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 15, 2011 at 10:13 am
keep in mind the engine states the error on your object 'dbo.Command' !
You'll have to investigate that table ( i assume ) and the indexes, constraints, .. on it.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 15, 2011 at 11:12 am
OK - here is a testdb. It has all the tables involved for the triggers to work. I have also included some test data at the end (commented out) to do the INSERT test with, as well as a FKey (also commented out) that is a normal part of the Batch & Customer tbls relationship. This will generate the error I am seeing with the Triggers enabled, when I do the INSERTS. It will error out on the first set of data (dbo.AlertLog), but oddly enough - all of the entries still wind up in all of the tbls. Is this just some sort of anomaly, or is my code just poorly construct for the trigger(s)?
Here's the script for you to try on your end. Again - this is in SQL Server 2005 SP3.
USE [master]
GO
--Drop the Test Database if it already exists
IF DB_ID('Test') IS NOT NULL
BEGIN
DROP DATABASE Test
END
/****** Object: Database [Test] Script Date: 12/30/2010 10:30:00 ******/
CREATE DATABASE [Test] ON PRIMARY
( NAME = N'Test_dat', FILENAME = N'C:\Temp\Test.mdf' , SIZE = 4288KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'Test_log', FILENAME = N'C:\Temp\Test.ldf' , SIZE = 1536KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
USE [Test]
GO
/*/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ THIS SECTION IS FOR TABLE CREATION CODE ENTRIES
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\*/
/****** Object: Table [dbo].[AlertLog] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AlertLog](
[AlertID] [int] NOT NULL,
[TreaterID] [int] NOT NULL,
[DTRaised] [datetime] NOT NULL,
[Description] [nvarchar](255) NULL,
[Priority] [nvarchar](20) NULL,
CONSTRAINT [PK_AlertLog] PRIMARY KEY CLUSTERED
(
[AlertID] ASC,
[TreaterID] ASC,
[DTRaised] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) 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'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Alert ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'AlertID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'64' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'AlertID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblAlerts' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'AlertID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Treater ID that generated the alert' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'TreaterID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'TreaterID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblAlerts' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date/Time Created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'DTCreated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'ShowDatePicker', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'DTCreated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblAlerts' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'DTRaised'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Alert Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'Description' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblAlerts' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Alert Priority' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Priority' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'20' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'Priority' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblAlerts' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog', @level2type=N'COLUMN',@level2name=N'Priority'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'DateCreated', @value=N'12/1/2010 8:27:01 PM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'DisplayViewsOnSharePointSite', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'FilterOnLoad', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'HIDeNewField', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'LastUpdated', @value=N'12/6/2010 9:42:54 PM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DefaultView', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_OrderByOn', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Orientation', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'tblAlerts' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'OrderByOnLoad', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'RecordCount', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'TotalsRow', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
EXEC sys.sp_addextendedproperty @name=N'Updatable', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AlertLog'
GO
/****** Object: Table [dbo].[Batch] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Batch](
[TreaterID] [int] NOT NULL,
[BatchID] [int] IDENTITY(1,1) NOT NULL,
[RecipeID] [int] NOT NULL,
[RecipeVersion] [smallint] NOT NULL,
[CustID] [int] NOT NULL,
[LotID] [int] NOT NULL,
[LoadNumber] [nvarchar](15) NULL,
[Temperature] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WindSpeed] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Notes] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SeedLotID] [bigint] NULL,
[SeedLotEntry] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SeedSize] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SeedUnits] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SeedVarietyID] [int] NOT NULL,
[WheelProduct] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WheelFlowRate] [float] NULL,
[WheelFlowUnits] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WheelTotal] [float] NULL,
[CustBatch] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DTStart] [datetime] NULL,
[DTEnd] [datetime] NULL,
[RunTime] [int] NULL,
[WarehouseID] [int] NOT NULL,
[CreatorID] [int] NOT NULL,
CONSTRAINT [PK_Batch] PRIMARY KEY CLUSTERED
(
[TreaterID] ASC,
[BatchID] ASC
)WITH (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'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'TreaterID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'TreaterID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'TreaterID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'17' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'BatchID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'BatchID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'BatchID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Recipe ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'RecipeID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'RecipeID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Recipe Version' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'RecipeVersion' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'RecipeVersion' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RecipeVersion'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Customer ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'CustID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'CustID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Seed lot used in Batch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'LotID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'5' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'LotID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'LotID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Temperature' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Temperature' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'6' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'Temperature' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Temperature'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Wind Speed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'WindSpeed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'7' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'WindSpeed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WindSpeed'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Notes' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Notes' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'Notes' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'Notes'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Seed Batch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'SeedBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'9' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'SeedBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedLotID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Seed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'SeedSize' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'SeedSize' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedSize'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Seed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'SeedUnits' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'11' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'SeedUnits' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Seed Variety' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'SeedVarietyID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'12' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'SeedVarietyID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'SeedVarietyID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Seed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'WheelProduct' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'13' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'WheelProduct' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelProduct'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Seed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'WheelFlowRate' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'14' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'WheelFlowRate' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowRate'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Seed' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'WheelFlowUnits' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'15' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'WheelFlowUnits' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelFlowUnits'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Seed Wheel Total' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'WheelTotal' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'16' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'WheelTotal' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'WheelTotal'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Customer Batch Reference' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'CustBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'17' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'CustBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'CustBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Start Date/Time' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'DTStart' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'18' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'ShowDatePicker', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'DTStart' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTStart'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch End Date/Time' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'DTEnd' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'19' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'ShowDatePicker', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'DTEnd' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'DTEnd'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Batch Run Time' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'RunTime' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'20' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'RunTime' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'7' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch', @level2type=N'COLUMN',@level2name=N'RunTime'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'DateCreated', @value=N'12/1/2010 8:02:41 PM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'DisplayViewsOnSharePointSite', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'FilterOnLoad', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'HIDeNewField', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'LastUpdated', @value=N'12/6/2010 2:40:32 PM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DefaultView', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_OrderByOn', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Orientation', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'tblBatch' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'OrderByOnLoad', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'RecordCount', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'TotalsRow', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'Updatable', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Batch'
GO
/****** Object: Table [dbo].[Command] ******/
CREATE TABLE [dbo].[Command](
[Requested] [datetime] NOT NULL CONSTRAINT [DF__Command__Request__5FB337D6] DEFAULT (getdate()),
[TableID] [smallint] NOT NULL,
[RecordID] [varchar](255) NOT NULL,
[Command] [smallint] NOT NULL CONSTRAINT [DF_Command_Command] DEFAULT (''),
[RetriesAttempted] [int] NOT NULL CONSTRAINT [DF_Command_Log] DEFAULT ((0)),
[Cancelled] [bit] NULL CONSTRAINT [DF_Command_Cancelled] DEFAULT ((0)),
[SentDate] [datetime] NULL CONSTRAINT [DF__Command__SentDat__619B8048] DEFAULT (NULL),
[ACKDate] [datetime] NULL CONSTRAINT [DF__Command__ACKDate__628FA481] DEFAULT (NULL),
[ResponseDate] [datetime] NULL CONSTRAINT [DF__Command__Respons__6383C8BA] DEFAULT (NULL),
[TimeoutDate] [datetime] NULL CONSTRAINT [DF__Command__Timeout__656C112C] DEFAULT (NULL),
[SecurityUserID] [uniqueidentifier] NULL,
[InterfaceHardwareIdentifierUsed] [varchar](50) NULL CONSTRAINT [DF_Command_Interface_Hardware_IDentifier] DEFAULT ((-1)),
CONSTRAINT [PK_Command] PRIMARY KEY CLUSTERED
(
[Requested] ASC,
[TableID] ASC,
[RecordID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Customer] Script Date: 12/21/2010 07:59:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Customer](
[TreaterID] [int] NOT NULL,
[CloudID] [int] NOT NULL,
[LocalID] [int] IDENTITY(1,1) NOT NULL,
[AccountNumber] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Firstname] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Lastname] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FarmName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address1] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address2] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [nvarchar](80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StateID] [smallint] NULL,
[PostalCode] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Phone] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Fax] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Email] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsActive] [bit] NOT NULL CONSTRAINT [DF__tblCustom__IsAct__09DE7BCC] DEFAULT ((0)),
[DTCreated] [datetime] NULL CONSTRAINT [DF_Customer_DTCreated] DEFAULT (getdate()),
[DTModified] [datetime] NULL CONSTRAINT [DF_Customer_DTModified] DEFAULT (getdate()),
[WarehouseID] [int] NOT NULL,
CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED
(
[WarehouseID] ASC,
[LocalID] ASC
)WITH (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'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Treater ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'TreaterID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'64' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'TreaterID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'WarehouseID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer ID -- TBD How this all works!!' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'CustID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'64' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'CustID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'CloudID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer Name' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'CustName' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'20' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'CustName' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Lastname'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer Address 1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Addr1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'40' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'Addr1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address1'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer Address 1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Addr2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'40' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'Addr2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Address2'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer City' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'City' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'5' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'80' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'City' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer State' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'StateID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'6' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'StateID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'StateID'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer Postal Code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'PostalCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'7' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'15' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'PostalCode' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'PostalCode'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer Phone Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Phone' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'15' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'Phone' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer FAX Number' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'Fax' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'9' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'15' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'Fax' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'DefaultValue', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer is Active' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'106' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Format', @value=N'Yes/No' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'IsActive' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'IsActive' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'IsActive'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date/Time Created' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'DTCreated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'11' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'ShowDatePicker', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'DTCreated' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTCreated'
GO
EXEC sys.sp_addextendedproperty @name=N'AggregateType', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'AppendOnly', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnHIDden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'ColumnWIDth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date/Time Modified' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMESentMode', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'DTModified' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'12' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'ShowDatePicker', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'DTModified' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'TextAlign', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer', @level2type=N'COLUMN',@level2name=N'DTModified'
GO
EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'DateCreated', @value=N'12/1/2010 7:27:16 PM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'DisplayViewsOnSharePointSite', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'FilterOnLoad', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'HIDeNewField', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'LastUpdated', @value=N'12/6/2010 9:54:22 PM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DefaultView', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_OrderByOn', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Orientation', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'tblCustomer' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'OrderByOnLoad', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'RecordCount', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'TotalsRow', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
EXEC sys.sp_addextendedproperty @name=N'Updatable', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Customer'
GO
/****** Object: Table [dbo].[Priming] ******/
CREATE TABLE [dbo].[Priming](
[TreaterID] [int] NOT NULL,
[TDStamp] [datetime] NOT NULL CONSTRAINT [DF_Priming_TDStamp] DEFAULT (getdate()),
[Usage] [float] NULL,
[KegID] [bigint] NOT NULL,
CONSTRAINT [PK_Priming] PRIMARY KEY CLUSTERED
(
[TreaterID] ASC,
[TDStamp] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/*/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ THIS SECTION IS FOR FOREIGN KEY RELATIONSHIP CODE ENTRIES
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\*/
/****** Object: ForeignKey [FK_Batch_Customer] Script Date: 02/08/2011 12:12:12 ******/
--ALTER TABLE [dbo].[Batch] WITH CHECK ADD CONSTRAINT [FK_Batch_Customer] FOREIGN KEY([WarehouseID],[CustID])
--REFERENCES [dbo].[Customer] ([WarehouseID],[LocalID])
--GO
--ALTER TABLE [dbo].[Batch] CHECK CONSTRAINT [FK_Batch_Customer]
--GO
/*/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ THIS SECTION IS FOR DML TRIGGERS
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\*/
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[Trg_AlertLogCommand]'))
DROP TRIGGER [dbo].[Trg_AlertLogCommand]
GO
--Create Trigger
CREATE TRIGGER Trg_AlertLogCommand
ON dbo.AlertLog
AFTER INSERT
AS
BEGIN
--Creates new Command table record when a row instert takes place on the Priming table. ~RWY 2/14/2011
INSERT INTO dbo.Command ([Requested],[TableID],[RecordID],[Command],[RetriesAttempted],[Cancelled])
SELECT DTRaised, '1', TreaterID, '0', '0', 'False'
FROM inserted
WHERE DTRaised IS NOT NULL
END
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[Trg_BatchCommand]'))
DROP TRIGGER [dbo].[Trg_BatchCommand]
GO
--Create Trigger
CREATE TRIGGER Trg_BatchCommand
ON dbo.Batch
AFTER UPDATE
AS
BEGIN
--Creates new Command table record when a Batch record is updated on the Treater. ~RWY 2/14/2011
INSERT INTO dbo.Command ([Requested],[TableID],[RecordID],[Command],[RetriesAttempted],[Cancelled])
SELECT DTStart, '3', CAST(TreaterID AS VARCHAR(5)) + '-' + CAST(BatchID AS VARCHAR(5)), '0', '0', 'False'
FROM inserted
WHERE DTEnd IS NOT NULL
END
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[Trg_CustomerCommand]'))
DROP TRIGGER [dbo].[Trg_CustomerCommand]
GO
--Create Trigger
CREATE TRIGGER Trg_CustomerCommand
ON dbo.Customer
AFTER INSERT
AS
BEGIN
--Creates new Command table record when a Customer is created on the Treater. ~RWY 2/14/2011
INSERT INTO dbo.Command ([Requested],[TableID],[RecordID],[Command],[RetriesAttempted],[Cancelled])
SELECT DTCreated, '6', CAST(TreaterID AS VARCHAR(5)) + '-' + CAST(LocalID AS VARCHAR(5)), '0', '0', 'False'
FROM inserted
WHERE CloudID IS NULL
END
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[Trg_PrimingCommand]'))
DROP TRIGGER [dbo].[Trg_PrimingCommand]
GO
--Create Trigger
CREATE TRIGGER Trg_PrimingCommand
ON dbo.Priming
AFTER INSERT
AS
BEGIN
--Creates new Command table record when a row instert takes place on the Priming table. ~RWY 2/14/2011
INSERT INTO dbo.Command ([Requested],[TableID],[RecordID],[Command],[RetriesAttempted],[Cancelled])
SELECT TDStamp, '19', TreaterID, '0', '0', 'False'
FROM inserted
WHERE TDStamp IS NOT NULL
END
SET NOCOUNT ON
GO
/*/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ THIS SECTION IS TEST DATA
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\*/
--SET NOCOUNT ON
--GO
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (1,1,'2/5/2011 10:25:05 AM','Station Pump Alert Station: 5','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (1,1,'2/5/2011 10:26:17 AM','Station Pump Alert Station: 5','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (1,1,'2/5/2011 10:28:31 AM','Station Pump Alert Station: 5','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (1,1,'2/5/2011 10:28:56 AM','Station Pump Alert Station: 5','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (1,1,'2/5/2011 10:29:42 AM','Station Pump Alert Station: 5','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (1,1,'2/10/2011 4:31:10 PM','Station Pump Alert Station: 1','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (1,1,'2/10/2011 4:57:24 PM','Station Pump Alert Station: 1','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (1,1,'2/10/2011 4:57:31 PM','Station Pump Alert Station: 1','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (1,1,'2/10/2011 4:59:07 PM','Station Pump Alert Station: 1','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (1,1,'2/10/2011 4:59:17 PM','Station Pump Alert Station: 1','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/10/2011 7:48:57 AM','Station Scale Alert Station: 8','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/10/2011 7:56:32 AM','Station Scale Alert Station: 8','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/10/2011 7:58:38 AM','Station Scale Alert Station: 8','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/10/2011 8:00:48 AM','Station Scale Alert Station: 8','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/10/2011 8:11:34 AM','Station Scale Alert Station: 8','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/10/2011 10:11:33 AM','Station Scale Alert Station: 8','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/10/2011 10:26:40 AM','Station Scale Alert Station: 6','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/10/2011 10:26:41 AM','Station Scale Alert Station: 8','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/10/2011 10:43:20 AM','Station Scale Alert Station: 3','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/11/2011 11:58:42 AM','Station Scale Alert Station: 1','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/11/2011 11:58:43 AM','Station Scale Alert Station: 2','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/11/2011 11:58:44 AM','Station Scale Alert Station: 3','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/11/2011 11:58:45 AM','Station Scale Alert Station: 4','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/11/2011 11:58:46 AM','Station Scale Alert Station: 5','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/11/2011 11:58:47 AM','Station Scale Alert Station: 6','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/11/2011 11:58:48 AM','Station Scale Alert Station: 7','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/11/2011 11:58:49 AM','Station Scale Alert Station: 8','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/12/2011 3:14:39 PM','Station Scale Alert Station: 1','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/12/2011 4:22:55 PM','Station Scale Alert Station: 1','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/12/2011 4:45:52 PM','Station Scale Alert Station: 4','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (2,1,'2/12/2011 4:46:08 PM','Station Scale Alert Station: 4','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:11:57 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:13:02 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:14:24 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:14:41 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:14:52 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:15:26 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:24:38 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:25:07 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:26:16 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:28:31 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:28:55 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:29:41 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:29:53 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:30:56 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:32:34 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:34:15 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 10:48:25 AM','Seed Wheel Motor Alert','High')
--INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority])
--VALUES (3,1,'2/5/2011 2:05:41 PM','Seed Wheel Motor Alert','High')
--
--SET NOCOUNT ON
--GO
--SET IDENTITY_INSERT [dbo].[Customer] ON
--GO
--INSERT [dbo].[Customer]([TreaterID],[CloudID],[LocalID],[AccountNumber],[Firstname],[Lastname],[FarmName],[Address1],[Address2],[City],[StateID],[PostalCode],[Phone],[Fax],[Email],[IsActive],[DTCreated],[DTModified],[WarehouseID])
--VALUES (1,1,1,'1','Tyler','Bryant','Bryant Farms','132 E Street','#12','Newport Beach',33,'92663','9495551212',NULL,NULL,1,'1/4/2011 3:24:00 PM','1/4/2011 3:24:00 PM',1)
--INSERT [dbo].[Customer]([TreaterID],[CloudID],[LocalID],[AccountNumber],[Firstname],[Lastname],[FarmName],[Address1],[Address2],[City],[StateID],[PostalCode],[Phone],[Fax],[Email],[IsActive],[DTCreated],[DTModified],[WarehouseID])
--VALUES (3,3,3,'1','Ree','Drummond','Daisy Hill Farms','123 West St','12','Okalahoma City',33,'34756','1234567890','1234567890','ree.drummond@mail.com',1,'1/17/2011 11:30:03 AM','1/17/2011 11:30:03 AM',2)
--INSERT [dbo].[Customer]([TreaterID],[CloudID],[LocalID],[AccountNumber],[Firstname],[Lastname],[FarmName],[Address1],[Address2],[City],[StateID],[PostalCode],[Phone],[Fax],[Email],[IsActive],[DTCreated],[DTModified],[WarehouseID])
--VALUES (2,4,2,NULL,'Jill','Schwarzenegger','Jill''s Farm','','','',34,'','5559996666',NULL,'JillSchwarzenegger@host.com',1,'1/17/2011 2:46:16 PM','1/17/2011 2:46:16 PM',3)
--INSERT [dbo].[Customer]([TreaterID],[CloudID],[LocalID],[AccountNumber],[Firstname],[Lastname],[FarmName],[Address1],[Address2],[City],[StateID],[PostalCode],[Phone],[Fax],[Email],[IsActive],[DTCreated],[DTModified],[WarehouseID])
--VALUES (4,5,4,'86786ax','Mike','Brown','Brown''s Farm','76 RR 3','','Mossenberg',28,'74523','6535482541',NULL,'mike@brown.com',1,'1/17/2011 3:17:17 PM','1/17/2011 3:17:17 PM',4)
--INSERT [dbo].[Customer]([TreaterID],[CloudID],[LocalID],[AccountNumber],[Firstname],[Lastname],[FarmName],[Address1],[Address2],[City],[StateID],[PostalCode],[Phone],[Fax],[Email],[IsActive],[DTCreated],[DTModified],[WarehouseID])
--VALUES (5,6,5,NULL,'Bill','Smith','Smith Farms','88 Cherry Lane','','Bismarck',35,'','7778889999',NULL,'bill_smith@yahoo.com',1,'1/17/2011 3:18:05 PM','1/17/2011 3:24:41 PM',5)
--INSERT [dbo].[Customer]([TreaterID],[CloudID],[LocalID],[AccountNumber],[Firstname],[Lastname],[FarmName],[Address1],[Address2],[City],[StateID],[PostalCode],[Phone],[Fax],[Email],[IsActive],[DTCreated],[DTModified],[WarehouseID])
--VALUES (6,7,6,'31221','Jerry Lee','Lewis','Lewis Farms','314 Big Sky Drive','','Bozeman',27,'34541','5172321559',NULL,'the-killer@pianoman.com',1,'1/17/2011 3:18:10 PM','1/17/2011 3:55:45 PM',6)
--INSERT [dbo].[Customer]([TreaterID],[CloudID],[LocalID],[AccountNumber],[Firstname],[Lastname],[FarmName],[Address1],[Address2],[City],[StateID],[PostalCode],[Phone],[Fax],[Email],[IsActive],[DTCreated],[DTModified],[WarehouseID])
--VALUES (7,8,7,'542','Bill','Smith','Bill''s Wheat Farm','3458 Middle of Nowhere','PO Box 67','Minneapolis',24,'54688','5558687895','5558687899','Bill.Smith@WheatFarm.com',1,'1/17/2011 3:18:10 PM','1/19/2011 1:24:53 PM',7)
--INSERT [dbo].[Customer]([TreaterID],[CloudID],[LocalID],[AccountNumber],[Firstname],[Lastname],[FarmName],[Address1],[Address2],[City],[StateID],[PostalCode],[Phone],[Fax],[Email],[IsActive],[DTCreated],[DTModified],[WarehouseID])
--VALUES (8,9,8,'84785477','John','Arbuckle','Funny Farm','123 Cty Rd 8','','Port Washington',50,'53074','1235945511',NULL,'jarbuckle@funnyfarm.com',1,'1/17/2011 3:18:36 PM','1/17/2011 3:18:36 PM',8)
--SET IDENTITY_INSERT [dbo].[Customer] OFF
--GO
--
--SET NOCOUNT ON
--GO
--SET IDENTITY_INSERT [dbo].[Batch] ON
--GO
--INSERT [dbo].[Batch]([TreaterID],[BatchID],[RecipeID],[RecipeVersion],[CustID],[LotID],[LoadNumber],[Temperature],[WindSpeed],[Notes],[SeedLotID],[SeedLotEntry],[SeedSize],[SeedUnits],[SeedVarietyID],[WheelProduct],[WheelFlowRate],[WheelFlowUnits],[WheelTotal],[CustBatch],[DTStart],[DTEnd],[RunTime],[WarehouseID],[CreatorID])
--VALUES (1,1,1,1,1,2,'1','100','10','None applicable',1,'1','1','1',1,'1',1,'1',1,'1','1/4/2011 12:00:00 AM','1/5/2001 12:00:00 AM',1,1,1)
--INSERT [dbo].[Batch]([TreaterID],[BatchID],[RecipeID],[RecipeVersion],[CustID],[LotID],[LoadNumber],[Temperature],[WindSpeed],[Notes],[SeedLotID],[SeedLotEntry],[SeedSize],[SeedUnits],[SeedVarietyID],[WheelProduct],[WheelFlowRate],[WheelFlowUnits],[WheelTotal],[CustBatch],[DTStart],[DTEnd],[RunTime],[WarehouseID],[CreatorID])
--VALUES (1,2,2,1,1,2,'2','100','10','None applicable',1,'1','1','1',1,'1',1,'1',1,'1','1/4/2011 12:00:00 AM','1/5/2001 12:00:00 AM',1,2,1)
--INSERT [dbo].[Batch]([TreaterID],[BatchID],[RecipeID],[RecipeVersion],[CustID],[LotID],[LoadNumber],[Temperature],[WindSpeed],[Notes],[SeedLotID],[SeedLotEntry],[SeedSize],[SeedUnits],[SeedVarietyID],[WheelProduct],[WheelFlowRate],[WheelFlowUnits],[WheelTotal],[CustBatch],[DTStart],[DTEnd],[RunTime],[WarehouseID],[CreatorID])
--VALUES (1,3,1,1,1,2,NULL,'100','10','None applicable',1,'1','1050','Kernals / LB',1,'1',800,'Kernals / Minute',2533,'10567','1/4/2011 12:00:00 AM','1/5/2001 12:00:00 AM',3,3,1)
--INSERT [dbo].[Batch]([TreaterID],[BatchID],[RecipeID],[RecipeVersion],[CustID],[LotID],[LoadNumber],[Temperature],[WindSpeed],[Notes],[SeedLotID],[SeedLotEntry],[SeedSize],[SeedUnits],[SeedVarietyID],[WheelProduct],[WheelFlowRate],[WheelFlowUnits],[WheelTotal],[CustBatch],[DTStart],[DTEnd],[RunTime],[WarehouseID],[CreatorID])
--VALUES (1,4,2,1,1,2,NULL,'100','10','None applicable',1,'1','900','Kernals / LB',2,'1',800,'Kernals / Minute',3020,'10568','1/4/2011 12:00:00 AM','1/5/2001 12:00:00 AM',5,4,1)
--INSERT [dbo].[Batch]([TreaterID],[BatchID],[RecipeID],[RecipeVersion],[CustID],[LotID],[LoadNumber],[Temperature],[WindSpeed],[Notes],[SeedLotID],[SeedLotEntry],[SeedSize],[SeedUnits],[SeedVarietyID],[WheelProduct],[WheelFlowRate],[WheelFlowUnits],[WheelTotal],[CustBatch],[DTStart],[DTEnd],[RunTime],[WarehouseID],[CreatorID])
--VALUES (2,5,1,1,1,2,NULL,'100','10','None applicable',1,'1','1050','Kernals / LB',1,'1',800,'Kernals / Minute',2533,'10569','1/4/2011 12:00:00 AM','1/5/2001 12:00:00 AM',2,5,1)
--INSERT [dbo].[Batch]([TreaterID],[BatchID],[RecipeID],[RecipeVersion],[CustID],[LotID],[LoadNumber],[Temperature],[WindSpeed],[Notes],[SeedLotID],[SeedLotEntry],[SeedSize],[SeedUnits],[SeedVarietyID],[WheelProduct],[WheelFlowRate],[WheelFlowUnits],[WheelTotal],[CustBatch],[DTStart],[DTEnd],[RunTime],[WarehouseID],[CreatorID])
--VALUES (2,6,2,1,1,2,NULL,'100','10','None applicable',1,'1','900','Kernals / LB',2,'1',800,'Kernals / Minute',3020,'10570','1/4/2011 12:00:00 AM','1/5/2001 12:00:00 AM',4,6,1)
--INSERT [dbo].[Batch]([TreaterID],[BatchID],[RecipeID],[RecipeVersion],[CustID],[LotID],[LoadNumber],[Temperature],[WindSpeed],[Notes],[SeedLotID],[SeedLotEntry],[SeedSize],[SeedUnits],[SeedVarietyID],[WheelProduct],[WheelFlowRate],[WheelFlowUnits],[WheelTotal],[CustBatch],[DTStart],[DTEnd],[RunTime],[WarehouseID],[CreatorID])
--VALUES (3,7,1,1,1,2,NULL,'100','10','None applicable',1,'1','1050','Kernals / LB',1,'1',800,'Kernals / Minute',2533,'10571','1/4/2011 12:00:00 AM','1/5/2001 12:00:00 AM',3,7,1)
--INSERT [dbo].[Batch]([TreaterID],[BatchID],[RecipeID],[RecipeVersion],[CustID],[LotID],[LoadNumber],[Temperature],[WindSpeed],[Notes],[SeedLotID],[SeedLotEntry],[SeedSize],[SeedUnits],[SeedVarietyID],[WheelProduct],[WheelFlowRate],[WheelFlowUnits],[WheelTotal],[CustBatch],[DTStart],[DTEnd],[RunTime],[WarehouseID],[CreatorID])
--VALUES (3,8,2,1,1,2,NULL,'100','10','None applicable',1,'1','900','Kernals / LB',2,'1',800,'Kernals / Minute',3020,'10572','1/4/2011 12:00:00 AM','1/5/2001 12:00:00 AM',2,8,1)
--INSERT [dbo].[Batch]([TreaterID],[BatchID],[RecipeID],[RecipeVersion],[CustID],[LotID],[LoadNumber],[Temperature],[WindSpeed],[Notes],[SeedLotID],[SeedLotEntry],[SeedSize],[SeedUnits],[SeedVarietyID],[WheelProduct],[WheelFlowRate],[WheelFlowUnits],[WheelTotal],[CustBatch],[DTStart],[DTEnd],[RunTime],[WarehouseID],[CreatorID])
--VALUES (4,9,1,1,1,2,NULL,'100','10','None applicable',1,'1','1050','Kernals / LB',1,'1',800,'Kernals / Minute',2533,'10573','1/4/2011 12:00:00 AM','1/5/2001 12:00:00 AM',6,1,1)
--INSERT [dbo].[Batch]([TreaterID],[BatchID],[RecipeID],[RecipeVersion],[CustID],[LotID],[LoadNumber],[Temperature],[WindSpeed],[Notes],[SeedLotID],[SeedLotEntry],[SeedSize],[SeedUnits],[SeedVarietyID],[WheelProduct],[WheelFlowRate],[WheelFlowUnits],[WheelTotal],[CustBatch],[DTStart],[DTEnd],[RunTime],[WarehouseID],[CreatorID])
--VALUES (4,10,2,1,1,2,NULL,'100','10','None applicable',1,'1','900','Kernals / LB',2,'1',800,'Kernals / Minute',3020,'10574','1/4/2011 12:00:00 AM','1/5/2001 12:00:00 AM',7,2,1)
--SET IDENTITY_INSERT [dbo].[Batch] OFF
--GO
--
--SET NOCOUNT ON
--GO
--INSERT [dbo].[Priming]([TreaterID],[TDStamp],[Usage],[KegID])
--VALUES (1,'2/11/2011 8:39:49 AM',4.5,26)
--INSERT [dbo].[Priming]([TreaterID],[TDStamp],[Usage],[KegID])
--VALUES (1,'2/11/2011 8:59:05 AM',5,6)
--INSERT [dbo].[Priming]([TreaterID],[TDStamp],[Usage],[KegID])
--VALUES (1,'2/11/2011 8:59:39 AM',-45,6)
And the error that is generated when you INSERT the data VALUES is as follows:
Msg 2627, Level 14, State 1, Procedure Trg_AlertLogCommand, Line 8
Violation of PRIMARY KEY constraint 'PK_Command'. Cannot insert duplicate key in object 'dbo.Command'.
The statement has been terminated.
Thank you again, and P.S. Don't bother with the FKey (it will just give you more errors that are not normally an issue in getting the data in).
February 15, 2011 at 11:40 am
Hi Rich,
The problem is the following data - which causes the duplicates in Command.
AlertIDTreaterIDDTRaised Description Priority
11 2011-02-05 10:28:31.000Station Pump Alert Station: 5 High
31 2011-02-05 10:28:31.000Seed Wheel Motor Alert High
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);February 15, 2011 at 11:42 am
From your very set of inserts it fails on this one
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority]) VALUES (3,1,'2/5/2011 10:28:31 AM','Seed Wheel Motor Alert','High')
because there is already a record in command with that primary key.
The insert way up top with
INSERT [dbo].[AlertLog]([AlertID],[TreaterID],[DTRaised],[Description],[Priority]) VALUES (1,1,'2/5/2011 10:28:31 AM','Station Pump Alert Station: 5','High')
is the first one...
You are going to have to back up a bit and figure out what exactly you are trying to do. At the very least you will need to redefine what the primary key if for your command table.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 15, 2011 at 12:40 pm
Hi Sean and Mister Magoo!
Yup - I was just coming out here to tell you guys that I found the problem (took the DATETIME data into Excel, and found it).
This is really bad. SQL 2005 only has the ability to go to 10ths of a second, and it's obvious that my hardware device could very well produce rows in that same instance.
For now - I am hoping that we don't wind up with a need to ever have to do more than one row at a time, but if the various scenarios you guys/gals came up with ever happens - I dunno (I wasn't part of the conceptual/logical discussions on this db when I arrived. It had been created a few months before I got here, and never went through normalization - obviously).
I'll have to see if there is another way around this, but I cannot thank you all enough for your time.
Have a great rest of the day and week!
February 15, 2011 at 12:44 pm
Best of luck. I would suggest coming up with a key that will guarantee uniqueness. Basically what you are doing is counting on the time to be your last step at making each record unique. As you can see that isn't going to cut it in the long run. Good luck with your project.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 15, 2011 at 1:22 pm
You know what? I just noticed from the postings by Sean and Mister Magoo, that those are not dups - they have different AlertID's.
So - that's not it.
:crazy:
Viewing 15 posts - 16 through 30 (of 32 total)
You must be logged in to reply to this topic. Login to reply