Stored Procedure taking more time to execute (Sql Server 2005)

• Tripz

  Ten Centuries

  Points: 1205

  More actions

  April 24, 2012 at 1:40 pm

  #254893

  I have a stored procedure implemented and calling of this stored proc from web page is taking more than 300ms, But when write the script in the web page and call the url, it is executing in 50ms

  What are the steps that are required to reduce the time to execute a stored proc. Why is sp taking more time than the db script in the page

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 24, 2012 at 1:42 pm

  #1478512

  Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  As a wild guess, maybe this: http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Tripz

  Ten Centuries

  Points: 1205

  More actions

  April 24, 2012 at 2:05 pm

  #1478534

  There are 4 steps in the Execution plan and I am adding them as attachment to this case

  and there 5 tables used in this procedure,

  Do you want me to paste the tables and indexes ?

  Thank you for the help

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 24, 2012 at 2:08 pm

  #1478536

  Which of those queries is the slow one?

  Yes please, table and index defs and please post the procedure.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Tripz

  Ten Centuries

  Points: 1205

  More actions

  April 24, 2012 at 2:43 pm

  #1478549

  Procedure

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  ALTER PROCEDURE [dbo].[usp_xxxxxx]

  (

  @user_emailaddress nvarchar(50)

  )

  AS

  BEGIN

  DECLARE @count_UserPreference int, @count_Teaser int

  DECLARE @categoryID nvarchar(50), @regionID nvarchar(50)

  SELECT @count_UserPreference = Count(*)

  FROM t_UserPreferences AS UP LEFT OUTER JOIN users AS U ON UP.userId = U.ID

  WHERE LTRIM(RTRIM(u.email)) = @user_emailaddress

  IF @count_UserPreference = 1

  BEGIN

  SELECT TOP 1

  @regionID = UP.region,@categoryID = UP.category

  FROM t_UserPreferences AS UP RIGHT OUTER JOIN users AS U ON UP.userId = U.ID

  WHERE u.email = @user_emailaddress

  END

  ELSE

  BEGIN

  SELECT TOP 1

  @categoryID = t_Categories.categoryId, @regionID = t_emailedSearchResults.regionId

  FROM t_Categories RIGHT OUTER JOIN

  t_emailedSearchResults ON t_Categories.categoryValue = t_emailedSearchResults.categoryvalue

  WHERE emailAddress = @user_emailaddress

  ORDER BY t_emailedSearchResults.createDate DESC

  END

  SELECT@count_Teaser = Count(*)

  FROMjobs

  LEFT OUTER JOIN t_Categories ON jobs.category = t_Categories.categoryValue

  LEFT OUTER JOIN t_Regions ON jobs.region = t_Regions.regionId

  IF /*@categoryID = 0 AND*/ Len(@categoryID) < 1

  --BEGIN

  SET @categoryID = ''

  --END--*/

  IF Len(@regionID) < 2 AND @regionID = 0

  --BEGIN

  SET @regionID = ''

  --END

  IF @count_Teaser = 0

  BEGIN

  --PRINT 'NO-count_Teaser '

  SELECT TOP 20

  jobs.sampleTitle, jobs.category, jobs.sampleCompanyName,

  jobs.ID, t_Regions.regionDescription, jobs.location

  FROM jobs

  LEFT OUTER JOIN t_Categories ON jobs.category = t_Categories.categoryValue

  LEFT OUTER JOIN t_Regions ON jobs.region = t_Regions.regionId

  WHERE len(jobs.sampleTitle) > 0

  AND (jobs.demo = 1 OR jobs.teaser = 1)

  ORDER BY jobs.timevar DESC

  END

  ELSE

  BEGIN

  IF IsNumeric(@categoryID)> 0 AND IsNumeric(@regionID) > 0

  BEGIN

  --PRINT '1'

  --PRINT @regionID

  EXEC ( 'SELECT TOP 20

  jobs.sampleTitle, jobs.category, jobs.sampleCompanyName, jobs.ID,

  t_Regions.regionDescription, jobs.location

  FROM jobs

  LEFT OUTER JOIN t_Categories ON jobs.category = t_Categories.categoryValue

  LEFT OUTER JOIN t_Regions ON jobs.region = t_Regions.regionId

  WHERE len(jobs.sampleTitle) > 0

  AND t_Categories.categoryID IN ('+ @categoryID + ')

  AND t_Regions.RegionID IN ('+ @regionID + ')

  AND jobs.teaser = 1

  ORDER BY jobs.timevar DESC' )

  END

  ELSE IF IsNumeric(@categoryID)> 0

  BEGIN

  --PRINT '2'

  EXEC ('SELECT TOP 20 jobs.sampleTitle, jobs.category, jobs.sampleCompanyName, jobs.ID, t_Regions.regionDescription, jobs.location

  FROM jobs LEFT OUTER JOIN t_Categories ON jobs.category = t_Categories.categoryValue LEFT OUTER JOIN t_Regions ON jobs.region = t_Regions.regionId WHERE len(jobs.sampleTitle) > 0 AND t_Categories.categoryID IN ('+ @categoryID +') AND jobs.teaser = 1 ORDER BY jobs.timevar DESC')

  END

  ELSE IF IsNumeric(@regionID) > 0

  BEGIN

  --PRINT '3'

  EXEC ('SELECT TOP 20

  jobs.sampleTitle, jobs.category, jobs.sampleCompanyName, jobs.ID,

  t_Regions.regionDescription, jobs.location

  FROM jobs

  LEFT OUTER JOIN t_Categories ON jobs.category = t_Categories.categoryValue

  LEFT OUTER JOIN t_Regions ON jobs.region = t_Regions.regionId

  WHERE len(jobs.sampleTitle) > 0

  AND t_Regions.RegionID IN ('+ @regionID+')

  AND jobs.teaser = 1

  ORDER BY jobs.timevar DESC')

  END

  ELSE

  BEGIN

  --PRINT 'from here'

  EXEC ('SELECT TOP 20 jobs.sampleTitle, jobs.category, jobs.sampleCompanyName, jobs.ID, t_Regions.regionDescription, jobs.location

  FROM jobs

  LEFT OUTER JOIN t_Categories ON jobs.category = t_Categories.categoryValue

  LEFT OUTER JOIN t_Regions ON jobs.region = t_Regions.regionId

  WHERE len(jobs.sampleTitle) > 0

  ANDjobs.teaser = 1

  ORDER BY jobs.timevar DESC')

  END

  END

  END

  ------------------================================

  TABLE 1

  ========

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  SET ANSI_PADDING ON

  GO

  CREATE TABLE [dbo].[jobs](

  [ID] [int] IDENTITY(1,1) NOT NULL,

  [category] [nvarchar](50) NULL,

  [region] [int] NULL,

  [timevar] [datetime] NULL,

  [jobno] [int] NULL,

  [company] [nvarchar](255) NULL,

  [state] [nvarchar](50) NULL,

  [location] [nvarchar](255) NULL,

  [title] [nvarchar](255) NULL,

  [description] [ntext] NULL,

  [contactname] [nvarchar](255) NULL,

  [contactfax] [nvarchar](255) NULL,

  [contactaddress] [nvarchar](255) NULL,

  [contactcity] [nvarchar](255) NULL,

  [contactstate] [nvarchar](255) NULL,

  [contactzip] [nvarchar](255) NULL,

  [contactemail] [nvarchar](255) NULL,

  [supplemental] [ntext] NULL,

  [comp-name] [nvarchar](50) NULL,

  [comp-logo] [nvarchar](50) NULL,

  [comp-id] [nvarchar](50) NULL,

  [approved] [nvarchar](2) NULL,

  [fulltimeparttime] [nvarchar](50) NULL,

  [experience] [nvarchar](50) NULL,

  [closingdate] [nvarchar](50) NULL,

  [salaryrangehigh] [nvarchar](50) NULL,

  [salaryrangelow] [nvarchar](50) NULL,

  [phonecalls] [nvarchar](50) NULL,

  [resumeconfirmation] [nvarchar](50) NULL,

  [rejectionletters] [nvarchar](50) NULL,

  [drugscreening] [nvarchar](50) NULL,

  [EOE] [nvarchar](50) NULL,

  [submittersname] [nvarchar](50) NULL,

  [submittersemail] [nvarchar](50) NULL,

  [empID] [nvarchar](25) NULL,

  [demo] [nvarchar](3) NULL,

  [upsize_ts] [timestamp] NULL,

  [sampleCompanyName] [varchar](255) NULL,

  [sampleTitle] [varchar](255) NULL,

  [sampleDescription] [text] NULL,

  [teaser] [nvarchar](3) NULL,

  [adminStatus] [char](3) NULL DEFAULT ('n'),

  [directLink] [ntext] NULL,

  [employerJobCode] [ntext] NULL

  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

  GO

  SET ANSI_PADDING OFF

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'17' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1024' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'category' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'category' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'category'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'region' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'region' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'region'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'timevar' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'timevar' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'timevar'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DecimalPlaces', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'jobno' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'jobno' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'jobno'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'company' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'5' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'company' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'company'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'state' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'6' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'state' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'state'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'location' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'7' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'location' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'location'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'title' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'8' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'title' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'title'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @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'jobs', @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'jobs', @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'jobs', @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'jobs', @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'jobs', @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'jobs', @level2type=N'COLUMN',@level2name=N'description'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @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'jobs', @level2type=N'COLUMN',@level2name=N'description'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'9' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @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'jobs', @level2type=N'COLUMN',@level2name=N'description'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @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'jobs', @level2type=N'COLUMN',@level2name=N'description'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'description'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'12' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @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'jobs', @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'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'contactname' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'contactname' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'contactfax' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'11' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'contactfax' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactfax'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'contactaddress' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'12' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'contactaddress' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactaddress'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'contactcity' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'13' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'contactcity' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactcity'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'contactstate' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'14' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'contactstate' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactstate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'contactzip' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'15' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'contactzip' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactzip'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'contactemail' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'16' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'255' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'contactemail' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'contactemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'supplemental' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'17' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'supplemental' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'12' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'supplemental'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'comp-name' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'18' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'comp-name' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-name'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'comp-logo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'19' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'comp-logo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-logo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'comp-id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'20' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'comp-id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'comp-id'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'approved' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'21' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'approved' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'fulltimeparttime' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'22' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'fulltimeparttime' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'fulltimeparttime'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'experience' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'23' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'experience' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'experience'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'closingdate' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'24' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'closingdate' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'closingdate'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'salaryrangehigh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'25' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'salaryrangehigh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangehigh'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'salaryrangelow' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'26' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'salaryrangelow' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'salaryrangelow'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'phonecalls' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'27' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'phonecalls' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'phonecalls'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'resumeconfirmation' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'28' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'resumeconfirmation' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'resumeconfirmation'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'rejectionletters' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'29' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'rejectionletters' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'rejectionletters'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'drugscreening' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'30' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'drugscreening' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'drugscreening'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'EOE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'31' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'EOE' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'EOE'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'submittersname' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'32' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'submittersname' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersname'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnOrder', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'ColumnWidth', @value=N'-1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'submittersemail' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'33' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'50' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'submittersemail' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'submittersemail'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'empID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'34' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'25' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'empID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'empID'

  GO

  EXEC sys.sp_addextendedproperty @name=N'AllowZeroLength', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'CollatingOrder', @value=N'1033' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DataUpdatable', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'GUID', @value=N'????????' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'demo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'35' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Required', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceField', @value=N'demo' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'SourceTable', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Type', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs', @level2type=N'COLUMN',@level2name=N'demo'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Attributes', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs'

  GO

  EXEC sys.sp_addextendedproperty @name=N'DateCreated', @value=N'7/27/2000 3:04:59 PM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs'

  GO

  EXEC sys.sp_addextendedproperty @name=N'LastUpdated', @value=N'12/4/2002 5:45:53 PM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_OrderByOn', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs'

  GO

  EXEC sys.sp_addextendedproperty @name=N'MS_Orientation', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Name', @value=N'jobs' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs'

  GO

  EXEC sys.sp_addextendedproperty @name=N'RecordCount', @value=N'1577' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs'

  GO

  EXEC sys.sp_addextendedproperty @name=N'Updatable', @value=N'True' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'jobs'

  Index for Table 1

  ==============

  CREATE NONCLUSTERED INDEX [_dta_index_jobs_15_802101898__K4D_1_2_3_8_38_39] ON [dbo].[jobs]

  (

  [timevar] DESC

  )

  INCLUDE ( [ID],

  [category],

  [region],

  [location],

  [sampleCompanyName],

  [sampleTitle]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

  TABLE 2

  =========

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  CREATE TABLE [dbo].[t_UserPreferences](

  [userId] [int] NOT NULL,

  [region] [nvarchar](max) NULL,

  [category] [nvarchar](max) NULL,

  CONSTRAINT [PK_t_UserPreferences_7Mar2012] PRIMARY KEY CLUSTERED

  (

  [userId] ASC

  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

  ) ON [PRIMARY]

  Index for Table 2

  ================

  ALTER TABLE [dbo].[t_UserPreferences] ADD CONSTRAINT [PK_t_UserPreferences_7Mar2012] PRIMARY KEY CLUSTERED

  (

  [userId] ASC

  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

  TABLE 3

  ========

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  SET ANSI_PADDING ON

  GO

  CREATE TABLE [dbo].[t_Regions](

  [regionId] [int] NOT NULL,

  [regionDescription] [varchar](50) NULL,

  [priority] [int] NOT NULL CONSTRAINT [DF_t_regions_priority] DEFAULT ((1)),

  CONSTRAINT [PK_t_regions_1] PRIMARY KEY CLUSTERED

  (

  [regionId] 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

  SET ANSI_PADDING OFF

  Index for Table 3

  ==============

  ALTER TABLE [dbo].[t_Regions] ADD CONSTRAINT [PK_t_regions_1] PRIMARY KEY CLUSTERED

  (

  [regionId] ASC

  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

  TABLE 4

  =========

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  SET ANSI_PADDING ON

  GO

  CREATE TABLE [dbo].[t_Categories](

  [categoryId] [int] IDENTITY(1,1) NOT NULL,

  [categoryDescription] [varchar](50) NULL,

  [categoryValue] [varchar](50) NULL,

  [priority] [int] NOT NULL CONSTRAINT [DF_t_Categories_priority] DEFAULT ((1)),

  [displayName] [varchar](50) NULL,

  CONSTRAINT [PK_t_Categories] PRIMARY KEY CLUSTERED

  (

  [categoryId] 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

  SET ANSI_PADDING OFF

  Index for Table 4

  ==============

  ALTER TABLE [dbo].[t_Categories] ADD CONSTRAINT [PK_t_Categories] PRIMARY KEY CLUSTERED

  (

  [categoryId] ASC

  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

  TABLE 5

  ========

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  SET ANSI_PADDING ON

  GO

  CREATE TABLE [dbo].[t_emailedSearchResults](

  [emailAddress] [varchar](60) NOT NULL,

  [categoryvalue] [varchar](50) NULL,

  [regionId] [int] NULL,

  [createDate] [datetime] NOT NULL,

  [fullname] [varchar](128) NULL,

  CONSTRAINT [PK_t_emailedSearchResults_7Mar2012] PRIMARY KEY CLUSTERED

  (

  [emailAddress] 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

  SET ANSI_PADDING OFF

  Index for Table 5

  ===============

  ALTER TABLE [dbo].[t_emailedSearchResults] ADD CONSTRAINT [PK_t_emailedSearchResults_7Mar2012] PRIMARY KEY CLUSTERED

  (

  [emailAddress] ASC

  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 24, 2012 at 2:56 pm

  #1478554

  Post them in this thread please.

  By sending them only to me you're requiring that only I help you.

  Edit, same with plans, please repost them here.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Tripz

  Ten Centuries

  Points: 1205

  More actions

  April 25, 2012 at 8:11 am

  #1479016

  Can any one help me to optimize the above proc

  Please check the attached - execution plans

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  April 25, 2012 at 8:22 am

  #1479030

  You still have not provided an actual execution plan. You can save a plan as a .sqlplan file and attach it to the thread.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  April 26, 2012 at 1:54 pm

  #1480062

  Test_plan-1.sqlplan

  It looks like you could benefit from an index on Users.ID that INCLUDEs email but I need to see the DDL to be sure. Can you please provide the DDL for the Users table?

  As a side note on the query:

  SELECT @count_UserPreference = COUNT(*)

  FROM t_UserPreferences AS UP

  LEFT OUTER JOIN users AS U ON UP.userId = U.ID

  WHERE LTRIM(RTRIM(u.email)) = @user_emailaddress

  When doing a LEFT OUTER JOIN if you have a predicate in the WHERE-clause filtering for a scalar value on the OUTER table you have essentially made the query into an INNER JOIN. So, you can restate your query this way and have the same logical result:

  SELECT @count_UserPreference = COUNT(*)

  FROM t_UserPreferences AS UP

  INNER JOIN users AS U ON UP.userId = U.ID

  WHERE LTRIM(RTRIM(u.email)) = @user_emailaddress

  If you really want an outer join then you want to rewrite it this way so the predicate is evaluated in the FROM clause, i.e. before the WHERE clause, which will change the logic of the query:

  SELECT @count_UserPreference = COUNT(*)

  FROM t_UserPreferences AS UP

  LEFT OUTER JOIN users AS U ON UP.userId = U.ID

  AND LTRIM(RTRIM(u.email)) = @user_emailaddress

  Note too that when you wrap a column with functions like LTRIM(), which has the potential to change the leading edge of the column value, you prevent SQL Server from using any indexes on the wrapped column. Are you worried about leading spaces? If so, I would recommend cleansing your data before it stored in the table and removing LTRIM() as opposed to keeping LTRIM() in place. You do not need the RTRIM at all by the way because the equality operator (=) does not consider trailing spaces on character-types, i.e. this prints Equal

  DECLARE @C CHAR(10) = 'asdf ',

  @d CHAR(10) = 'asdf';

  IF @C = @d

  PRINT 'Equal'

  I'll look into the other three as I have time...

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• Tripz

  Ten Centuries

  Points: 1205

  More actions

  April 27, 2012 at 9:39 am

  #1480526

  Hi,

  Thank You for the suggestion of using AND instead of WHERE in the LEFT JOIN, I updated my sp with those changes and the stored proc execution time reduced from 250ms to 130ms.

  Also - I ALTERed the user table and removed the sp_addextendedproperty.

  now the sp time reduced from 130ms to 110ms

  Can you please help me to reduce the time further.

  Also - how can I call a stored proc for 250k times for different email address.

  Thank You

  Tripz

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  April 27, 2012 at 10:17 am

  #1480560

  Tripz (4/27/2012)

  ---

  Hi,

  Thank You for the suggestion of using AND instead of WHERE in the LEFT JOIN, I updated my sp with those changes and the stored proc execution time reduced from 250ms to 130ms.

  Also - I ALTERed the user table and removed the sp_addextendedproperty.

  now the sp time reduced from 130ms to 110ms

  Can you please help me to reduce the time further.

  Also - how can I call a stored proc for 250k times for different email address.

  Thank You

  Tripz

  Also, removing extended properties from the database will not affect performance, but thank you for not continuing to post calls to sp_addextendedproperty on the Forum mixed in with your other code...they are irrelevant for performance so only produce clutter here.

  Can you please post the DDL for the Users table? Did you consider adding the index per my recommendation? That ought to give you the best performance gain.

  Re: calling a proc for 250 different emails here are a couple options:

  1. Use Dynamic SQL to build a string containing a batch of commands to call the proc 250 times with different emails.

  DECLARE @sql NVARCHAR(MAX)

  SET @sql = N'';

  SELECT @sql = @sql + 'EXEC dbo.ProcName @EmailAddress = ''' + EmailAddressColumn + ''';'

  FROM dbo.TableName

  WHERE ColumnName = 'blah';

  EXEC(@sql);

  2. Write a CURSOR to iterate over the rows containing the emails and call the proc 250 times sequentially.

  DECLARE @EmailAddress VARCHAR(200);

  DECLARE EmailCursor CURSOR FAST_FORWARD READ_ONLY

  FOR SELECT EmailAddressColumn

  FROM dbo.TableName

  WHERE ColumnName = 'blah';

  OPEN EmailCursor

  FETCH NEXT FROM EmailCursor INTO @EmailAddress

  WHILE @@FETCH_STATUS = 0

  BEGIN

  EXEC dbo.ProcName

  @EmailAddressParameter = @EmailAddress

  FETCH NEXT FROM EmailCursor INTO @EmailAddress

  END

  CLOSE EmailCursor

  DEALLOCATE EmailCursor

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• Tripz

  Ten Centuries

  Points: 1205

  More actions

  April 27, 2012 at 3:50 pm

  #1480753

  Thank You - I am able to test the stored proc using cursor, for some reason I am not able to execute to first approch but second approach helped me.

  Can you help me with the next steps to improve the stored proc further.

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  April 27, 2012 at 3:55 pm

  #1480754

  Happy to hear things are improving...please help us help you...

  opc.three (4/26/2012)

  ---

  It looks like you could benefit from an index on Users.ID that INCLUDEs email but I need to see the DDL to be sure. Can you please provide the DDL for the Users table?

  opc.three (4/27/2012)

  ---

  Can you please post the DDL for the Users table? Did you consider adding the index per my recommendation? That ought to give you the best performance gain.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato