Improve performace of a simple query

• Tripz

  Ten Centuries

  Points: 1205

  More actions

  June 4, 2012 at 12:48 pm

  #270048

  Hi

  I have a simple query

  SELECTu.ID, u.username, u.password, u.email, u.firstname, u.lastname,

  u.userTypeID, r.resume_name, r.file_pointer, u.approved, u.expdate,

  u.expireddate, up.region, up.category, u.yearsOfExperience,

  u.WillingToRelocate, u.SportsExperience, u.dateTimeEntered,

  dbo.fn_getUserCategoryList(u.ID) as categoryList,

  dbo.fn_getUserRegionList (u.ID) as regionList

  FROM aaaa u

  LEFT OUTER JOIN bbbb up ON u.ID = up.userId

  LEFT OUTER JOIN cccc r ON dbo.u.ID = r.user_id

  WHERE (u.userTypeID IN (1, 2))

  But this query is taking more than 3min to execute

  Can someone help me to fig-out the issue and fix it

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  June 4, 2012 at 1:26 pm

  #1496710

  Really need more information to help you. If you would read the second article I reference in my signature block it will tell you what information we need and how to post it to help you with your performance issue.

  One thing I notice are the two scalar UDFs you call in the SELECT list. These could be part of your problem so you should also post the DDL for these two functions as well.

• Tripz

  Ten Centuries

  Points: 1205

  More actions

  June 4, 2012 at 2:02 pm

  #1496745

  Hi

  Thank you

  Here is the DDL of the functions

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

  ALTER FUNCTION [dbo].[fn_getUserCategoryList](@userID int)

  RETURNS VARCHAR(MAX)

  AS

  BEGIN

  DECLARE @list nvarchar(64)

  SELECT @list = category FROM t_UserPreferences WHERE userID = @userid

  DECLARE @listStr VARCHAR(MAX)

  SELECT@listStr = COALESCE(@listStr+', ' ,'') + T.CategoryValue

  FROMt_categories T

  WHERET.CategoryID in ((select value from fn_split(@list,',')))

  RETURN @listStr

  END

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

  ALTER FUNCTION [dbo].[fn_getUserRegionList](@userID int)

  RETURNS VARCHAR(MAX)

  AS

  BEGIN

  DECLARE @list nvarchar(64)

  SELECT @list = region FROM t_UserPreferences WHERE userID = @userid

  DECLARE @listStr VARCHAR(MAX)

  SELECT@listStr = COALESCE(@listStr+', ' ,'') + R.regionDescription

  FROMt_regions R

  WHERER.regionID in ((select value from fn_split(@list,',')))

  RETURN @listStr

  END

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

  There are indexes for both the table aaaa, bbbb and cccc

  CREATE NONCLUSTERED INDEX userid_email

  ON dbo.aaaa(id)

  INCLUDE (email)

  CREATE NONCLUSTERED INDEX userpreference_categoryregion

  ON dbo.bbbb(userid)

  INCLUDE (region,category)

  CREATE NONCLUSTERED INDEX resume_users

  ON dbo.cccc(resume_id)

  INCLUDE (user_id)

  AND

  ALTER TABLE [dbo].[cccc] ADD CONSTRAINT [PK_resumes] PRIMARY KEY CLUSTERED

  (

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

  ALTER TABLE [dbo].[aaaa] ADD CONSTRAINT [users_id_PK] PRIMARY KEY CLUSTERED

  (

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

  ALTER TABLE [dbo].[bbbb] ADD CONSTRAINT [PK_t_UserPreferences] 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]

  Please let me know if this helps

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 4, 2012 at 2:04 pm

  #1496747

  Execution plan please

  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

  June 4, 2012 at 2:06 pm

  #1496749

  Please check the attached -- Actual execution plan from Sql Server 2005.

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  June 4, 2012 at 2:15 pm

  #1496755

  Tripz (6/4/2012)

  ---

  Hi

  Thank you

  Here is the DDL of the functions

  How about fn_split?

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  June 4, 2012 at 2:15 pm

  #1496757

  And the DDL for the tables and the execution plan.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 4, 2012 at 2:18 pm

  #1496759

  First thing, get rid of those functions. Data-accessing scalar UDFs are performance nightmares. Use an inline table-valued UDF or a subquery to get the lists.

  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

  June 4, 2012 at 2:47 pm

  #1496776

  Here is the Data Definition for the 3 tables

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

  USE [jis_www_dev]

  GO

  /****** Object: Table [dbo].[aaaa] Script Date: 06/04/2012 15:31:00 ******/

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  SET ANSI_PADDING ON

  GO

  CREATE TABLE [dbo].[aaaa](

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

  [username] [nvarchar](50) NULL,

  [password] [nvarchar](50) NULL,

  [nvarchar](50) NULL,

  [firstname] [nvarchar](25) NULL,

  [lastname] [nvarchar](25) NULL,

  [setup] [nvarchar](50) NULL,

  [city] [nvarchar](75) NULL,

  [state] [nvarchar](75) NULL,

  [zip] [nvarchar](25) NULL,

  [daysleft] [int] NULL,

  [address] [nvarchar](250) NULL,

  [address2] [nvarchar](250) NULL,

  [phone] [nvarchar](25) NULL,

  [country] [nvarchar](10) NULL,

  [acctype] [nvarchar](10) NULL,

  [emaillist] [nvarchar](50) NULL,

  [approved] [nvarchar](50) NULL,

  [ccard] [nvarchar](50) NULL,

  [expdate] [nvarchar](50) NULL,

  [expireddate] [datetime] NULL,

  [emailsent] [datetime] NULL,

  [dateTimeEntered] [datetime] NULL,

  [isEmploymentApplication] [bit] NULL,

  [userTypeID] [int] NULL,

  [ExperienceLevel] [nvarchar](50) NULL,

  [SportsExperience] [bit] NULL,

  [FirstTime] [bit] NULL,

  [location1] [varchar](20) NULL,

  [locationOther] [varchar](200) NULL,

  [yearsOfExperience] [nvarchar](50) NULL,

  [WillingToRelocate] [int] NULL,

  CONSTRAINT [users_id_PK] PRIMARY KEY CLUSTERED

  (

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

  EXEC sys.sp_addextendedproperty @name=N'UnicodeCompression', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'users', @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'users', @level2type=N'COLUMN',@level2name=N'zip'

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'75' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'users', @level2type=N'COLUMN',@level2name=N'address'

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'users', @level2type=N'COLUMN',@level2name=N'country'

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

  EXEC sys.sp_addextendedproperty @name=N'Size', @value=N'10' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'users', @level2type=N'COLUMN',@level2name=N'acctype'

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'19' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'users', @level2type=N'COLUMN',@level2name=N'ccard'

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

  EXEC sys.sp_addextendedproperty @name=N'OrdinalPosition', @value=N'20' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'users', @level2type=N'COLUMN',@level2name=N'expdate'

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

  EXEC sys.sp_addextendedproperty @name=N'DateCreated', @value=N'3/26/2001 10:31:38 AM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'users'

  GO

  EXEC sys.sp_addextendedproperty @name=N'LastUpdated', @value=N'10/29/2003 4:35:49 PM' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'users'

  GO

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

  GO

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

  GO

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

  GO

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

  GO

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

  GO

  ALTER TABLE [dbo].[aaaa] ADD CONSTRAINT [DF_users_dateTimeEntered] DEFAULT (getdate()) FOR [dateTimeEntered]

  GO

  ALTER TABLE [dbo].[aaaa] ADD CONSTRAINT [DF_users_isEmploymentApplication] DEFAULT ((0)) FOR [isEmploymentApplication]

  GO

  ALTER TABLE [dbo].[aaaa] ADD CONSTRAINT [DF_users_FirstTime_1] DEFAULT ((0)) FOR [FirstTime]

  GO

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

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  CREATE TABLE [dbo].[bbbb](

  [userId] [int] NOT NULL,

  [region] [nvarchar](max) NULL,

  [category] [nvarchar](max) NULL,

  CONSTRAINT [PK_t_UserPreferences] 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]

  GO

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

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  CREATE TABLE [dbo].[cccc](

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

  [user_id] [int] NULL,

  [resume_name] [nvarchar](250) NULL,

  [file_pointer] [nvarchar](250) NULL,

  [first_name] [nvarchar](250) NULL,

  [last_name] [nvarchar](250) NULL,

  [address_1] [nvarchar](250) NULL,

  [address_2] [nvarchar](250) NULL,

  [city] [nvarchar](250) NULL,

  [state] [nvarchar](250) NULL,

  [zip] [nvarchar](250) NULL,

  [country] [nvarchar](250) NULL,

  [nvarchar](250) NULL,

  [school_type_1] [nvarchar](250) NULL,

  [school_name_1] [nvarchar](250) NULL,

  [school_city_1] [nvarchar](250) NULL,

  [school_state_1] [nvarchar](250) NULL,

  [school_country_1] [nvarchar](250) NULL,

  [degree_1] [nvarchar](250) NULL,

  [school_start_date_1] [nvarchar](50) NULL,

  [school_end_date_1] [nvarchar](50) NULL,

  [school_comments_1] [nvarchar](max) NULL,

  [school_type_2] [nvarchar](250) NULL,

  [school_name_2] [nvarchar](250) NULL,

  [school_city_2] [nvarchar](250) NULL,

  [school_state_2] [nvarchar](250) NULL,

  [school_country_2] [nvarchar](250) NULL,

  [degree_2] [nvarchar](250) NULL,

  [school_start_date_2] [nvarchar](50) NULL,

  [school_end_date_2] [nvarchar](50) NULL,

  [school_comments_2] [nvarchar](max) NULL,

  [school_type_3] [nvarchar](250) NULL,

  [school_name_3] [nvarchar](250) NULL,

  [school_city_3] [nvarchar](250) NULL,

  [school_state_3] [nvarchar](250) NULL,

  [school_country_3] [nvarchar](250) NULL,

  [degree_3] [nvarchar](250) NULL,

  [school_start_date_3] [nvarchar](50) NULL,

  [school_end_date_3] [nvarchar](50) NULL,

  [school_comments_3] [nvarchar](max) NULL,

  [career_objectives] [nvarchar](max) NULL,

  [company_name_1] [nvarchar](250) NULL,

  [company_city_1] [nvarchar](250) NULL,

  [company_state_1] [nvarchar](250) NULL,

  [company_country_1] [nvarchar](250) NULL,

  [company_start_date_1] [nvarchar](50) NULL,

  [company_end_date_1] [nvarchar](50) NULL,

  [position_title_1] [nvarchar](250) NULL,

  [company_comments_1] [nvarchar](max) NULL,

  [company_name_2] [nvarchar](250) NULL,

  [company_city_2] [nvarchar](250) NULL,

  [company_state_2] [nvarchar](250) NULL,

  [company_country_2] [nvarchar](250) NULL,

  [company_start_date_2] [nvarchar](50) NULL,

  [company_end_date_2] [nvarchar](50) NULL,

  [position_title_2] [nvarchar](250) NULL,

  [company_comments_2] [nvarchar](max) NULL,

  [company_name_3] [nvarchar](250) NULL,

  [company_city_3] [nvarchar](250) NULL,

  [company_state_3] [nvarchar](250) NULL,

  [company_country_3] [nvarchar](250) NULL,

  [company_start_date_3] [nvarchar](50) NULL,

  [company_end_date_3] [nvarchar](50) NULL,

  [position_title_3] [nvarchar](250) NULL,

  [company_comments_3] [nvarchar](max) NULL,

  [company_name_4] [nvarchar](250) NULL,

  [company_city_4] [nvarchar](250) NULL,

  [company_state_4] [nvarchar](250) NULL,

  [company_country_4] [nvarchar](250) NULL,

  [company_start_date_4] [nvarchar](50) NULL,

  [company_end_date_4] [nvarchar](50) NULL,

  [position_title_4] [nvarchar](250) NULL,

  [company_comments_4] [nvarchar](max) NULL,

  [user_phone] [nvarchar](250) NULL,

  [user_fax] [nvarchar](250) NULL,

  [hobby_title_1] [nvarchar](50) NULL,

  [hobby_1] [nvarchar](max) NULL,

  [hobby_title_2] [nvarchar](50) NULL,

  [hobby_2] [nvarchar](max) NULL,

  [hobby_title_3] [nvarchar](50) NULL,

  [hobby_3] [nvarchar](max) NULL,

  [reference_1] [nvarchar](250) NULL,

  [reference_2] [nvarchar](250) NULL,

  [reference_3] [nvarchar](250) NULL,

  [AdditionalInfoFlag] [bit] NULL,

  [ExperienceLevel] [nvarchar](50) NULL,

  [SportsExperience] [bit] NULL,

  CONSTRAINT [PK_resumes] PRIMARY KEY CLUSTERED

  (

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

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

• Tripz

  Ten Centuries

  Points: 1205

  More actions

  June 4, 2012 at 3:21 pm

  #1496796

  How do I get rid of

  EXEC sys.sp_addextendedproperty @name=N'GUID' from the table CREATE SCRIPT of the table

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  June 5, 2012 at 7:57 am

  #1497057

  WOW your datatypes are a disaster. I don't mean to sound insulting but these tables have so many problems it is hard to comment on all of them.

  --------------------------

  Table AAA

  --------------------------

  password column - shouldn't you be storing a computed hash instead of plain text? If so, the field size should match the size of the hash.

  email - 50 isn't long enough and you don't need nvarchar.

  In general you seem to like using nvarchar instead of the appropriate varchar.

  Zip code never going to be 25 characters long with extended characters.

  ccard - This should NEVER be stored in your database unless you really know what you are doing. I am guessing that you are storing the card number in plain text. This is INCREDIBLY dangerous!!!! This is far worse than the poorly designed tables. Even if you are deadset on storing this data the longest CC num is 16 characters and they are only digits. No need for nvarchar.

  expdate - this should be a datetime.

  --------------------------

  Table BBB

  --------------------------

  region - nvarchar(max)? You should have a region table and this would be the foreign key. Even if you want to denormalize your data that is not the right datatype.

  category - see region.

  --------------------------

  Table CCC

  --------------------------

  still using nvarchar all over the place.

  zip has now increased to 250 characters!!

  country went from 10 to 250!!!

  Then we get into school_type_1, etc. This should be another table or a series of tables. What are you going to do when you want to add a 5th Company?

  --------------------------

  Ranting over.

  --------------------------

  OK so it is obvious you need a LOT of help on your table structure. Some of your performance problems come from these poorly designed tables. Another part of the issue is all of your columns are nullable except for the identity.

  So we have poorly designed tables that allow nulls across the board and there are no indexes. Add to that the nested scalar functions and you have what should be a simple query taking over 3 minutes to run.

  From the execution plan you posted, the query was SELECT * FROM [qry_GetUsers]

  Is that a stored proc?

  We still need to code for your split function and qry_GetUsers. Also these functions are referencing other tables. In order to replace these functions with something less painful we need those tables too.

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• Tripz

  Ten Centuries

  Points: 1205

  More actions

  June 5, 2012 at 10:13 am

  #1497165

  Hi,

  Thank You for all the details. I will take your points and do the fixing as suggested.

  [qry_GetUsers] is a view.

  The query in the view is nothing but the below query

  SELECT u.ID, u.username, u.password, u.email, u.firstname, u.lastname,

  u.userTypeID, r.resume_name, r.file_pointer, u.approved, u.expdate,

  u.expireddate, up.region, up.category, u.yearsOfExperience,

  u.WillingToRelocate, u.SportsExperience, u.dateTimeEntered,

  dbo.fn_getUserCategoryList(u.ID) as categoryList,

  dbo.fn_getUserRegionList (u.ID) as regionList

  FROM aaaa u

  LEFT OUTER JOIN bbbb up ON u.ID = up.userId

  LEFT OUTER JOIN cccc r ON dbo.u.ID = r.user_id

  WHERE (u.userTypeID IN (1, 2))

  and fn_split code is as follow

  ALTER FUNCTION [dbo].[fn_Split](@text varchar(8000), @delimiter varchar(20) = ' ')

  RETURNS @Strings TABLE

  (

  position int IDENTITY PRIMARY KEY,

  value varchar(8000)

  )

  AS

  BEGIN

  DECLARE @index int

  SET @index = -1

  WHILE (LEN(@text) > 0)

  BEGIN

  SET @index = CHARINDEX(@delimiter , @text)

  IF (@index = 0) AND (LEN(@text) > 0)

  BEGIN

  INSERT INTO @Strings VALUES (@text)

  BREAK

  END

  IF (@index > 1)

  BEGIN

  INSERT INTO @Strings VALUES (LEFT(@text, @index - 1))

  SET @text = RIGHT(@text, (LEN(@text) - @index))

  END

  ELSE

  SET @text = RIGHT(@text, (LEN(@text) - @index))

  END

  RETURN

  END

  The problem is

  SELECT * FROM [qry_GetUsers] is taking around 4min to execute.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  June 5, 2012 at 10:20 am

  #1497168

  Sean Lange (6/5/2012)

  ---

  WOW your datatypes are a disaster. I don't mean to sound insulting but these tables have so many problems it is hard to comment on all of them.

  --------------------------

  Table AAA

  --------------------------

  password column - shouldn't you be storing a computed hash instead of plain text? If so, the field size should match the size of the hash.

  email - 50 isn't long enough and you don't need nvarchar.

  In general you seem to like using nvarchar instead of the appropriate varchar.

  Zip code never going to be 25 characters long with extended characters.

  ccard - This should NEVER be stored in your database unless you really know what you are doing. I am guessing that you are storing the card number in plain text. This is INCREDIBLY dangerous!!!! This is far worse than the poorly designed tables. Even if you are deadset on storing this data the longest CC num is 16 characters and they are only digits. No need for nvarchar.

  expdate - this should be a datetime.

  --------------------------

  Table BBB

  --------------------------

  region - nvarchar(max)? You should have a region table and this would be the foreign key. Even if you want to denormalize your data that is not the right datatype.

  category - see region.

  --------------------------

  Table CCC

  --------------------------

  still using nvarchar all over the place.

  zip has now increased to 250 characters!!

  country went from 10 to 250!!!

  Then we get into school_type_1, etc. This should be another table or a series of tables. What are you going to do when you want to add a 5th Company?

  --------------------------

  Ranting over.

  --------------------------

  OK so it is obvious you need a LOT of help on your table structure. Some of your performance problems come from these poorly designed tables. Another part of the issue is all of your columns are nullable except for the identity.

  So we have poorly designed tables that allow nulls across the board and there are no indexes. Add to that the nested scalar functions and you have what should be a simple query taking over 3 minutes to run.

  From the execution plan you posted, the query was SELECT * FROM [qry_GetUsers]

  Is that a stored proc?

  We still need to code for your split function and qry_GetUsers. Also these functions are referencing other tables. In order to replace these functions with something less painful we need those tables too.

  From OP's second post:

  There are indexes for both the table aaaa, bbbb and cccc

  CREATE NONCLUSTERED INDEX userid_email

  ON dbo.aaaa(id)

  INCLUDE (email)

  CREATE NONCLUSTERED INDEX userpreference_categoryregion

  ON dbo.bbbb(userid)

  INCLUDE (region,category)

  CREATE NONCLUSTERED INDEX resume_users

  ON dbo.cccc(resume_id)

  INCLUDE (user_id)

  AND

  ALTER TABLE [dbo].[cccc] ADD CONSTRAINT [PK_resumes] PRIMARY KEY CLUSTERED

  (

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

  ALTER TABLE [dbo].[aaaa] ADD CONSTRAINT [users_id_PK] PRIMARY KEY CLUSTERED

  (

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

  ALTER TABLE [dbo].[bbbb] ADD CONSTRAINT [PK_t_UserPreferences] 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]

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  June 5, 2012 at 10:32 am

  #1497174

  OK so to compile all of the details we have so far into a single post, here is the ddl as you have posted.

  CREATE TABLE [dbo].[aaaa] (

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

  ,[username] [nvarchar](50) NULL

  ,[password] [nvarchar](50) NULL

  , [nvarchar](50) NULL

  ,[firstname] [nvarchar](25) NULL

  ,[lastname] [nvarchar](25) NULL

  ,[setup] [nvarchar](50) NULL

  ,[city] [nvarchar](75) NULL

  ,[state] [nvarchar](75) NULL

  ,[zip] [nvarchar](25) NULL

  ,[daysleft] [int] NULL

  ,[address] [nvarchar](250) NULL

  ,[address2] [nvarchar](250) NULL

  ,[phone] [nvarchar](25) NULL

  ,[country] [nvarchar](10) NULL

  ,[acctype] [nvarchar](10) NULL

  ,[emaillist] [nvarchar](50) NULL

  ,[approved] [nvarchar](50) NULL

  ,[ccard] [nvarchar](50) NULL

  ,[expdate] [nvarchar](50) NULL

  ,[expireddate] [datetime] NULL

  ,[emailsent] [datetime] NULL

  ,[dateTimeEntered] [datetime] NULL

  ,[isEmploymentApplication] [bit] NULL

  ,[userTypeID] [int] NULL

  ,[ExperienceLevel] [nvarchar](50) NULL

  ,[SportsExperience] [bit] NULL

  ,[FirstTime] [bit] NULL

  ,[location1] [varchar](20) NULL

  ,[locationOther] [varchar](200) NULL

  ,[yearsOfExperience] [nvarchar](50) NULL

  ,[WillingToRelocate] [int] NULL

  ,CONSTRAINT [users_id_PK] PRIMARY KEY CLUSTERED ([ID] 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

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ID'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'username'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'50'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'username'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'username'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'password'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'3'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'50'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'password'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'password'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'email'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'4'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'50'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'email'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'email'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'firstname'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'5'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'25'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'firstname'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'firstname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'lastname'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'6'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'25'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'lastname'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'lastname'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'setup'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'7'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'50'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'setup'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'setup'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'city'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'8'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'25'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'city'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'city'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'state'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'9'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'state'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'25'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'state'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'state'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'zip'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'25'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'zip'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'zip'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DecimalPlaces'

  ,@value = N'255'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'daysleft'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'11'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'4'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'daysleft'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'4'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'daysleft'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'address'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'12'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'75'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'address'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'address2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'13'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'25'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'address2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'address2'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'phone'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'14'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'25'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'phone'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'phone'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'country'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'15'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'country'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'country'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'acctype'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'16'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'acctype'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'acctype'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'emaillist'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'17'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'50'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'emaillist'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emaillist'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'18'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'50'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'approved'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@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'users'

  ,@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'users'

  ,@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'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'ccard'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'19'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'50'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'ccard'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'ccard'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'2'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'GUID'

  ,@value = N'????????'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_DisplayControl'

  ,@value = N'109'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'expdate'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'20'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'50'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'expdate'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'10'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'UnicodeCompression'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expdate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'expireddate'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'21'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'8'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'expireddate'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'8'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'expireddate'

  GO

  EXEC sys.sp_addextendedproperty @name = N'AllowZeroLength'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'CollatingOrder'

  ,@value = N'1033'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnHidden'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnOrder'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'ColumnWidth'

  ,@value = N'-1'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DataUpdatable'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'emailsent'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'OrdinalPosition'

  ,@value = N'22'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Required'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Size'

  ,@value = N'8'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceField'

  ,@value = N'emailsent'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'SourceTable'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Type'

  ,@value = N'8'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  ,@level2type = N'COLUMN'

  ,@level2name = N'emailsent'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Attributes'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  GO

  EXEC sys.sp_addextendedproperty @name = N'DateCreated'

  ,@value = N'3/26/2001 10:31:38 AM'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  GO

  EXEC sys.sp_addextendedproperty @name = N'LastUpdated'

  ,@value = N'10/29/2003 4:35:49 PM'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_OrderByOn'

  ,@value = N'False'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  GO

  EXEC sys.sp_addextendedproperty @name = N'MS_Orientation'

  ,@value = N'0'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Name'

  ,@value = N'users'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  GO

  EXEC sys.sp_addextendedproperty @name = N'RecordCount'

  ,@value = N'18305'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  GO

  EXEC sys.sp_addextendedproperty @name = N'Updatable'

  ,@value = N'True'

  ,@level0type = N'SCHEMA'

  ,@level0name = N'dbo'

  ,@level1type = N'TABLE'

  ,@level1name = N'users'

  GO

  ALTER TABLE [dbo].[aaaa] ADD CONSTRAINT [DF_users_dateTimeEntered] DEFAULT(getdate())

  FOR [dateTimeEntered]

  GO

  ALTER TABLE [dbo].[aaaa] ADD CONSTRAINT [DF_users_isEmploymentApplication] DEFAULT((0))

  FOR [isEmploymentApplication]

  GO

  ALTER TABLE [dbo].[aaaa] ADD CONSTRAINT [DF_users_FirstTime_1] DEFAULT((0))

  FOR [FirstTime]

  GO

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

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  CREATE TABLE [dbo].[bbbb] (

  [userId] [int] NOT NULL

  ,[region] [nvarchar](max) NULL

  ,[category] [nvarchar](max) NULL

  ,CONSTRAINT [PK_t_UserPreferences] 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]

  GO

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

  SET ANSI_NULLS ON

  GO

  SET QUOTED_IDENTIFIER ON

  GO

  CREATE TABLE [dbo].[cccc] (

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

  ,[user_id] [int] NULL

  ,[resume_name] [nvarchar](250) NULL

  ,[file_pointer] [nvarchar](250) NULL

  ,[first_name] [nvarchar](250) NULL

  ,[last_name] [nvarchar](250) NULL

  ,[address_1] [nvarchar](250) NULL

  ,[address_2] [nvarchar](250) NULL

  ,[city] [nvarchar](250) NULL

  ,[state] [nvarchar](250) NULL

  ,[zip] [nvarchar](250) NULL

  ,[country] [nvarchar](250) NULL

  , [nvarchar](250) NULL

  ,[school_type_1] [nvarchar](250) NULL

  ,[school_name_1] [nvarchar](250) NULL

  ,[school_city_1] [nvarchar](250) NULL

  ,[school_state_1] [nvarchar](250) NULL

  ,[school_country_1] [nvarchar](250) NULL

  ,[degree_1] [nvarchar](250) NULL

  ,[school_start_date_1] [nvarchar](50) NULL

  ,[school_end_date_1] [nvarchar](50) NULL

  ,[school_comments_1] [nvarchar](max) NULL

  ,[school_type_2] [nvarchar](250) NULL

  ,[school_name_2] [nvarchar](250) NULL

  ,[school_city_2] [nvarchar](250) NULL

  ,[school_state_2] [nvarchar](250) NULL

  ,[school_country_2] [nvarchar](250) NULL

  ,[degree_2] [nvarchar](250) NULL

  ,[school_start_date_2] [nvarchar](50) NULL

  ,[school_end_date_2] [nvarchar](50) NULL

  ,[school_comments_2] [nvarchar](max) NULL

  ,[school_type_3] [nvarchar](250) NULL

  ,[school_name_3] [nvarchar](250) NULL

  ,[school_city_3] [nvarchar](250) NULL

  ,[school_state_3] [nvarchar](250) NULL

  ,[school_country_3] [nvarchar](250) NULL

  ,[degree_3] [nvarchar](250) NULL

  ,[school_start_date_3] [nvarchar](50) NULL

  ,[school_end_date_3] [nvarchar](50) NULL

  ,[school_comments_3] [nvarchar](max) NULL

  ,[career_objectives] [nvarchar](max) NULL

  ,[company_name_1] [nvarchar](250) NULL

  ,[company_city_1] [nvarchar](250) NULL

  ,[company_state_1] [nvarchar](250) NULL

  ,[company_country_1] [nvarchar](250) NULL

  ,[company_start_date_1] [nvarchar](50) NULL

  ,[company_end_date_1] [nvarchar](50) NULL

  ,[position_title_1] [nvarchar](250) NULL

  ,[company_comments_1] [nvarchar](max) NULL

  ,[company_name_2] [nvarchar](250) NULL

  ,[company_city_2] [nvarchar](250) NULL

  ,[company_state_2] [nvarchar](250) NULL

  ,[company_country_2] [nvarchar](250) NULL

  ,[company_start_date_2] [nvarchar](50) NULL

  ,[company_end_date_2] [nvarchar](50) NULL

  ,[position_title_2] [nvarchar](250) NULL

  ,[company_comments_2] [nvarchar](max) NULL

  ,[company_name_3] [nvarchar](250) NULL

  ,[company_city_3] [nvarchar](250) NULL

  ,[company_state_3] [nvarchar](250) NULL

  ,[company_country_3] [nvarchar](250) NULL

  ,[company_start_date_3] [nvarchar](50) NULL

  ,[company_end_date_3] [nvarchar](50) NULL

  ,[position_title_3] [nvarchar](250) NULL

  ,[company_comments_3] [nvarchar](max) NULL

  ,[company_name_4] [nvarchar](250) NULL

  ,[company_city_4] [nvarchar](250) NULL

  ,[company_state_4] [nvarchar](250) NULL

  ,[company_country_4] [nvarchar](250) NULL

  ,[company_start_date_4] [nvarchar](50) NULL

  ,[company_end_date_4] [nvarchar](50) NULL

  ,[position_title_4] [nvarchar](250) NULL

  ,[company_comments_4] [nvarchar](max) NULL

  ,[user_phone] [nvarchar](250) NULL

  ,[user_fax] [nvarchar](250) NULL

  ,[hobby_title_1] [nvarchar](50) NULL

  ,[hobby_1] [nvarchar](max) NULL

  ,[hobby_title_2] [nvarchar](50) NULL

  ,[hobby_2] [nvarchar](max) NULL

  ,[hobby_title_3] [nvarchar](50) NULL

  ,[hobby_3] [nvarchar](max) NULL

  ,[reference_1] [nvarchar](250) NULL

  ,[reference_2] [nvarchar](250) NULL

  ,[reference_3] [nvarchar](250) NULL

  ,[AdditionalInfoFlag] [bit] NULL

  ,[ExperienceLevel] [nvarchar](50) NULL

  ,[SportsExperience] [bit] NULL

  ,CONSTRAINT [PK_resumes] PRIMARY KEY CLUSTERED ([resume_id] 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

  create FUNCTION [dbo].[fn_getUserCategoryList] (@userID INT)

  RETURNS VARCHAR(MAX)

  AS

  BEGIN

  DECLARE @list NVARCHAR(64)

  SELECT @list = category

  FROM t_UserPreferences

  WHERE userID = @userid

  DECLARE @listStr VARCHAR(MAX)

  SELECT @listStr = COALESCE(@listStr + ', ', '') + T.CategoryValue

  FROM t_categories T

  WHERE T.CategoryID IN (

  (

  SELECT value

  FROM fn_split(@list, ',')

  )

  )

  RETURN @listStr

  END

  GO

  create FUNCTION [dbo].[fn_getUserRegionList] (@userID INT)

  RETURNS VARCHAR(MAX)

  AS

  BEGIN

  DECLARE @list NVARCHAR(64)

  SELECT @list = region

  FROM t_UserPreferences

  WHERE userID = @userid

  DECLARE @listStr VARCHAR(MAX)

  SELECT @listStr = COALESCE(@listStr + ', ', '') + R.regionDescription

  FROM t_regions R

  WHERE R.regionID IN (

  (

  SELECT value

  FROM fn_split(@list, ',')

  )

  )

  RETURN @listStr

  END

  go

  CREATE NONCLUSTERED INDEX userid_email ON dbo.aaaa (id) INCLUDE (email)

  CREATE NONCLUSTERED INDEX userpreference_categoryregion ON dbo.bbbb (userid) INCLUDE (

  region

  ,category

  )

  CREATE NONCLUSTERED INDEX resume_users ON dbo.cccc (resume_id) INCLUDE (user_id)

  ALTER TABLE [dbo].[cccc] ADD CONSTRAINT [PK_resumes] PRIMARY KEY CLUSTERED ([resume_id] 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]

  ALTER TABLE [dbo].[aaaa] ADD CONSTRAINT [users_id_PK] PRIMARY KEY CLUSTERED ([ID] 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]

  ALTER TABLE [dbo].[bbbb] ADD CONSTRAINT [PK_t_UserPreferences] 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]

  Notice the little scrolling windows with these long posts. To do that yourself you can use the IFCode shortcuts. They are on the left side when you are posting. It helps make these long post more readable.

  oops forgot the Split function.

  ALTER FUNCTION [dbo].[fn_Split] (

  @text VARCHAR(8000)

  ,@delimiter VARCHAR(20) = ' '

  )

  RETURNS @Strings TABLE (

  position INT IDENTITY PRIMARY KEY

  ,value VARCHAR(8000)

  )

  AS

  BEGIN

  DECLARE @index INT

  SET @index = - 1

  WHILE (LEN(@text) > 0)

  BEGIN

  SET @index = CHARINDEX(@delimiter, @text)

  IF (@index = 0)

  AND (LEN(@text) > 0)

  BEGIN

  INSERT INTO @Strings

  VALUES (@text)

  BREAK

  END

  IF (@index > 1)

  BEGIN

  INSERT INTO @Strings

  VALUES (LEFT(@text, @index - 1))

  SET @text = RIGHT(@text, (LEN(@text) - @index))

  END

  ELSE

  SET @text = RIGHT(@text, (LEN(@text) - @index))

  END

  RETURN

  END

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• Alexander Suprun

  SSCertifiable

  Points: 6253

  More actions

  June 5, 2012 at 10:34 am

  #1497177

  Tripz (6/4/2012)

  ---

  Hi

  Thank you

  Here is the DDL of the functions

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

  ALTER FUNCTION [dbo].[fn_getUserCategoryList](@userID int)

  RETURNS VARCHAR(MAX)

  AS

  BEGIN

  DECLARE @list nvarchar(64)

  SELECT @list = category FROM t_UserPreferences WHERE userID = @userid

  DECLARE @listStr VARCHAR(MAX)

  SELECT@listStr = COALESCE(@listStr+', ' ,'') + T.CategoryValue

  FROMt_categories T

  WHERET.CategoryID in ((select value from fn_split(@list,',')))

  RETURN @listStr

  END

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

  ALTER FUNCTION [dbo].[fn_getUserRegionList](@userID int)

  RETURNS VARCHAR(MAX)

  AS

  BEGIN

  DECLARE @list nvarchar(64)

  SELECT @list = region FROM t_UserPreferences WHERE userID = @userid

  DECLARE @listStr VARCHAR(MAX)

  SELECT@listStr = COALESCE(@listStr+', ' ,'') + R.regionDescription

  FROMt_regions R

  WHERER.regionID in ((select value from fn_split(@list,',')))

  RETURN @listStr

  END

  Do you keep category and region as comma separated strings? Bad. Bad design. Create 2 separate tables for categories and regions attached to the users. And as was said already get rid of those functions, they are performance killers!

  ---

  Alex Suprun