Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Running .sql script and getting errors

Author  Topic 

simmerdeeps
Starting Member

1 Post
Posted - 2012-09-22 : 17:14:28
i just installed SQL Server 2008 and I am trying to run a script which will create database and tables but I am getting errors while running it. I generated this script from my old laptop.

Below is the script


USE [master]
GO
/****** Object: Database [evite] Script Date: 05/06/2012 12:58:56 ******/
CREATE DATABASE [evite] ON PRIMARY
( NAME = N'evite', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\evite.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'evite_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\evite_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [evite] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [evite].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [evite] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [evite] SET ANSI_NULLS OFF
GO
ALTER DATABASE [evite] SET ANSI_PADDING OFF
GO
ALTER DATABASE [evite] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [evite] SET ARITHABORT OFF
GO
ALTER DATABASE [evite] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [evite] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [evite] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [evite] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [evite] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [evite] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [evite] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [evite] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [evite] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [evite] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [evite] SET DISABLE_BROKER
GO
ALTER DATABASE [evite] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [evite] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [evite] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [evite] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [evite] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [evite] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [evite] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [evite] SET READ_WRITE
GO
ALTER DATABASE [evite] SET RECOVERY FULL
GO
ALTER DATABASE [evite] SET MULTI_USER
GO
ALTER DATABASE [evite] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [evite] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'evite', N'ON'
GO
USE [evite]
GO
/****** Object: Table [dbo].[e_CardCategory] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_CardCategory](
[eCardCategoryKey] [int] IDENTITY(1,1) NOT NULL,
[eCardCategory] [nvarchar](300) NOT NULL,
[eActive] [int] NOT NULL,
CONSTRAINT [PK_e_CardCategory] PRIMARY KEY CLUSTERED
(
[eCardCategoryKey] 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 IDENTITY_INSERT [dbo].[e_CardCategory] ON
INSERT [dbo].[e_CardCategory] ([eCardCategoryKey], [eCardCategory], [eActive]) VALUES (1, N'Anniversary', 1)
INSERT [dbo].[e_CardCategory] ([eCardCategoryKey], [eCardCategory], [eActive]) VALUES (2, N'Birthday', 1)
INSERT [dbo].[e_CardCategory] ([eCardCategoryKey], [eCardCategory], [eActive]) VALUES (3, N'Christmas', 1)
INSERT [dbo].[e_CardCategory] ([eCardCategoryKey], [eCardCategory], [eActive]) VALUES (4, N'Congratulations', 1)
INSERT [dbo].[e_CardCategory] ([eCardCategoryKey], [eCardCategory], [eActive]) VALUES (5, N'Friendship', 1)
INSERT [dbo].[e_CardCategory] ([eCardCategoryKey], [eCardCategory], [eActive]) VALUES (6, N'Graduation', 1)
INSERT [dbo].[e_CardCategory] ([eCardCategoryKey], [eCardCategory], [eActive]) VALUES (7, N'Halloween', 1)
INSERT [dbo].[e_CardCategory] ([eCardCategoryKey], [eCardCategory], [eActive]) VALUES (8, N'Valentines Day', 1)
SET IDENTITY_INSERT [dbo].[e_CardCategory] OFF
/****** Object: Table [dbo].[e_CountryCode] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_CountryCode](
[eCountryCodeKey] [int] IDENTITY(1,1) NOT NULL,
[eCountryCode] [nvarchar](50) NOT NULL,
[eCountryName] [nvarchar](50) NOT NULL,
[eActive] [int] NOT NULL,
[eRegion] [int] NOT NULL,
CONSTRAINT [PK_e_CountryCode] PRIMARY KEY CLUSTERED
(
[eCountryCodeKey] 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 IDENTITY_INSERT [dbo].[e_CountryCode] ON
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (1, N'ABW', N'Aruba', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (2, N'AGO', N'Angola', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (3, N'AIA', N'Anguilla', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (4, N'ALB', N'Albania', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (5, N'AND', N'Andorra', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (6, N'ANT', N'Antilles, Netherlands', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (7, N'ARE', N'United Arab Emirates', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (8, N'ARG', N'Argentina', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (9, N'ARM', N'Armenia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (10, N'ASM', N'American Samoa', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (11, N'ATA', N'Antarctica', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (12, N'ATF', N'French Southern Territories', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (13, N'ATG', N'Antigua and Barbuda', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (14, N'AUS', N'Australia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (15, N'AUT', N'Austria', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (16, N'AZE', N'Azerbaijan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (17, N'BDI', N'Burundi', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (18, N'BEL', N'Belgium', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (19, N'BEN', N'Benin', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (20, N'BFA', N'Burkina Faso', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (21, N'BGD', N'Bangladesh', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (22, N'BGR', N'Bulgaria', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (23, N'BHR', N'Bahrain', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (24, N'BHS', N'Bahamas', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (25, N'BIH', N'Bosnia and Herzegovina', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (26, N'BLR', N'Belarus', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (27, N'BLZ', N'Belize', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (28, N'BMU', N'Bermuda', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (29, N'BOL', N'Bolivia', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (30, N'BRA', N'Brazil', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (31, N'BRB', N'Barbados', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (32, N'BRN', N'Brunei Darussalam', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (33, N'BTN', N'Bhutan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (34, N'BVT', N'Bouvet Island', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (35, N'BWA', N'Botswana', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (36, N'CAF', N'Central African Republic', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (37, N'CAN', N'Canada', 1, 1)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (38, N'CCK', N'Cocos (keeling) Islands', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (39, N'CDC', N'CDC', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (40, N'CHE', N'Switzerland', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (41, N'CHL', N'Chile', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (42, N'CHN', N'China', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (43, N'CIV', N'Cote D''ivoire', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (44, N'CMR', N'Cameroon', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (45, N'COD', N'Congo, The Democratic Republic of the', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (46, N'COG', N'Congo', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (47, N'COK', N'Cook Islands', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (48, N'COL', N'Colombia', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (49, N'COM', N'Comoros', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (50, N'CPV', N'Cape Verde', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (51, N'CRI', N'Costa Rica', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (52, N'CUB', N'Cuba', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (53, N'CXR', N'Christmas Island', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (54, N'CYM', N'Cayman Islands', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (55, N'CYP', N'Cyprus', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (56, N'CZE', N'Czech Republic', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (57, N'DEU', N'Germany', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (58, N'DJI', N'Djibouti', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (59, N'DMA', N'Dominica', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (60, N'DNK', N'Denmark', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (61, N'DOM', N'Dominican Republic', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (62, N'DZA', N'Algeria', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (63, N'ECU', N'Ecuador', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (64, N'EGY', N'Egypt', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (65, N'ERI', N'Eritrea', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (66, N'ESH', N'Western Sahara', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (67, N'ESP', N'Spain', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (68, N'EST', N'Estonia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (69, N'ETH', N'Ethiopia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (70, N'FIN', N'Finland', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (71, N'FJI', N'Fiji', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (72, N'FLK', N'Falkland Islands (malvinas)', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (73, N'FRA', N'France', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (74, N'FRO', N'Faroe Islands', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (75, N'FSM', N'Micronesia, Federated States of', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (76, N'GAB', N'Gabon', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (77, N'GBR', N'United Kingdom', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (78, N'GEO', N'Georgia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (79, N'GHA', N'Ghana', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (80, N'GIB', N'Gibraltar', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (81, N'GIN', N'Guinea', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (82, N'GLP', N'Guadeloupe', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (83, N'GMB', N'Gambia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (84, N'GNB', N'Guinea-bissau', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (85, N'GNQ', N'Equatorial Guinea', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (86, N'GRC', N'Greece', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (87, N'GRD', N'Grenada', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (88, N'GRL', N'Greenland', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (89, N'GTM', N'Guatemala', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (90, N'GUF', N'French Guiana', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (91, N'GUM', N'Guam', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (92, N'GUY', N'Guyana', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (93, N'HKG', N'Hong Kong', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (94, N'HMD', N'Heard Island and Mcdonald Islands', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (95, N'HND', N'Honduras', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (96, N'HRV', N'Croatia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (97, N'HTI', N'Haiti', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (98, N'HUN', N'Hungary', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (99, N'IDN', N'Indonesia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (100, N'IND', N'India', 0, 0)
GO
print 'Processed 100 total records'
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (101, N'IOT', N'British Indian Ocean Territory', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (102, N'IRL', N'Ireland', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (103, N'IRN', N'Iran, Islamic Republic of', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (104, N'IRQ', N'Iraq', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (105, N'ISL', N'Iceland', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (106, N'ISR', N'Israel', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (107, N'ITA', N'Italy', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (108, N'JAM', N'Jamaica', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (109, N'JOR', N'Jordan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (110, N'JPN', N'Japan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (111, N'KAZ', N'Kazakstan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (112, N'KEN', N'Kenya', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (113, N'KGZ', N'Kyrgyzstan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (114, N'KHM', N'Cambodia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (115, N'KIR', N'Kiribati', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (116, N'KNA', N'Saint Kitts and Nevis', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (117, N'KOR', N'Korea, Republic of (South)', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (118, N'KWT', N'Kuwait', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (119, N'LAO', N'Lao People''s Democratic Republic', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (120, N'LBN', N'Lebanon', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (121, N'LBR', N'Liberia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (122, N'LBY', N'Libyan Arab Jamahiriya', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (123, N'LCA', N'Saint Lucia', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (124, N'LIE', N'Liechtenstein', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (125, N'LKA', N'Sri Lanka', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (126, N'LSO', N'Lesotho', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (127, N'LTU', N'Lithuania', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (128, N'LUX', N'Luxembourg', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (129, N'LVA', N'Latvia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (130, N'MAC', N'Macau', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (131, N'MAR', N'Morocco', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (132, N'MCO', N'Monaco', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (133, N'MDA', N'Moldova, Republic of', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (134, N'MDG', N'Madagascar', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (135, N'MDV', N'Maldives', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (136, N'MEX', N'Mexico', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (137, N'MHL', N'Marshall Islands', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (138, N'MKD', N'Macedonia, The Former Yugoslav Republic of', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (139, N'MLI', N'Mali', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (140, N'MLT', N'Malta', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (141, N'MMR', N'Myanmar', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (142, N'MNG', N'Mongolia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (143, N'MNP', N'Saipan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (144, N'MOZ', N'Mozambique', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (145, N'MRT', N'Mauritania', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (146, N'MSR', N'Montserrat', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (147, N'MTQ', N'Martinique', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (148, N'MUS', N'Mauritius', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (149, N'MWI', N'Malawi', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (150, N'MYS', N'Malaysia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (151, N'MYT', N'Mayotte', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (152, N'NAM', N'Namibia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (153, N'NCL', N'New Caledonia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (154, N'NER', N'Niger', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (155, N'NFK', N'Norfolk Island', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (156, N'NGA', N'Nigeria', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (157, N'NIC', N'Nicaragua', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (158, N'NIU', N'Niue', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (159, N'NLD', N'Netherlands', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (160, N'NOR', N'Norway', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (161, N'NPL', N'Nepal', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (162, N'NRU', N'Nauru', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (163, N'NZL', N'New Zealand', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (164, N'OMN', N'Oman', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (165, N'PAK', N'Pakistan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (166, N'PAN', N'Panama', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (167, N'PCN', N'Pitcairn', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (168, N'PER', N'Peru', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (169, N'PHL', N'Philippines', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (170, N'PLW', N'Palau', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (171, N'PNG', N'Papua New Guinea', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (172, N'POL', N'Poland', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (173, N'PRI', N'Puerto Rico', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (174, N'PRK', N'Korea, Democratic People''s Republic of (North)', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (175, N'PRT', N'Portugal', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (176, N'PRY', N'Paraguay', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (177, N'PSE', N'Palestinian Territory, Occupied', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (178, N'PYF', N'French Polynesia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (179, N'QAT', N'Qatar', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (180, N'REU', N'Reunion', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (181, N'ROM', N'Romania', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (182, N'RUS', N'Russian Federation', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (183, N'RWA', N'Rwanda', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (184, N'SAU', N'Saudi Arabia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (185, N'SDN', N'Sudan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (186, N'SEN', N'Senegal', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (187, N'SGP', N'Singapore', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (188, N'SGS', N'South Georgia and the South Sandwich Islands', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (189, N'SHN', N'Saint Helena', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (190, N'SJM', N'Svalbard and Jan Mayen', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (191, N'SLB', N'Solomon Islands', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (192, N'SLE', N'Sierra Leone', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (193, N'SLV', N'El Salvador', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (194, N'SMR', N'San Marino', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (195, N'SOM', N'Somalia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (196, N'SPM', N'Saint Pierre and Miquelon', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (197, N'STP', N'Sao Tome and Principe', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (198, N'SUR', N'Suriname', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (199, N'SVK', N'Slovakia (slovak Republic)', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (200, N'SVN', N'Slovenia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (201, N'SWE', N'Sweden', 0, 0)
GO
print 'Processed 200 total records'
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (202, N'SWZ', N'Swaziland', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (203, N'SYC', N'Seychelles', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (204, N'SYR', N'Syrian Arab Republic', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (205, N'TCA', N'Turks and Caicos Islands', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (206, N'TCD', N'Chad', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (207, N'TGO', N'Togo', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (208, N'THA', N'Thailand', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (209, N'TJK', N'Tajikistan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (210, N'TKL', N'Tokelau', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (211, N'TKM', N'Turkmenistan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (212, N'TMP', N'East Timor', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (213, N'TON', N'Tonga', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (214, N'TTO', N'Trinidad and Tobago', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (215, N'TUN', N'Tunisia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (216, N'TUR', N'Turkey', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (217, N'TUV', N'Tuvalu', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (218, N'TWN', N'Taiwan, Province of China', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (219, N'TZA', N'Tanzania, United Republic of', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (220, N'UGA', N'Uganda', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (221, N'UKR', N'Ukraine', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (222, N'UMI', N'United States Minor Outlying Islands', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (223, N'URY', N'Uruguay', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (224, N'USA', N'USA', 1, 1)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (225, N'USH', N'USA,Hawaii', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (226, N'UZB', N'Uzbekistan', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (227, N'VAT', N'Holy See (vatican City State)', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (228, N'VCT', N'Saint Vincent and the Grenadines', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (229, N'VEN', N'Venezuela', 1, 3)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (230, N'VGB', N'Virgin Islands, British', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (231, N'VIR', N'Virgin Islands, U.S.', 1, 2)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (232, N'VNM', N'Vietnam', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (233, N'VUT', N'Vanuatu', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (234, N'WLF', N'Wallis and Futuna', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (235, N'WSM', N'Samoa', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (236, N'YEM', N'Yemen, South', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (237, N'YES', N'Yemen, North', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (238, N'YUG', N'Yugoslavia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (239, N'ZAF', N'South Africa', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (240, N'ZMB', N'Zambia', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (241, N'ZWE', N'Zimbabwe', 0, 0)
INSERT [dbo].[e_CountryCode] ([eCountryCodeKey], [eCountryCode], [eCountryName], [eActive], [eRegion]) VALUES (242, N'OTH', N'OTHER', 0, 0)
SET IDENTITY_INSERT [dbo].[e_CountryCode] OFF
/****** Object: Table [dbo].[e_InvitationDetails] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_InvitationDetails](
[eEventInvitationKey] [int] IDENTITY(1,1) NOT NULL,
[eEventTitle] [nvarchar](50) NOT NULL,
[eEventCategory] [int] NOT NULL,
[eEventCreatorLoginKey] [int] NOT NULL,
[eEventHostName] [nvarchar](50) NOT NULL,
[eEventHostContact] [nvarchar](50) NOT NULL,
[eEventDate] [datetime] NOT NULL,
[eEventTime] [nvarchar](50) NOT NULL,
[eEventampm] [nvarchar](50) NOT NULL,
[eEventVenueName] [nvarchar](50) NOT NULL,
[eEventAddress1] [nvarchar](50) NOT NULL,
[eEventAddress2] [nvarchar](50) NOT NULL,
[eEventCity] [nvarchar](50) NOT NULL,
[eEventState] [int] NOT NULL,
[eEventProvince] [nvarchar](50) NOT NULL,
[eEventCountry] [int] NOT NULL,
[eEventZip] [nvarchar](50) NOT NULL,
[eInvitationMessage] [nvarchar](150) NOT NULL,
[eEventStatus] [int] NOT NULL,
[eEventFriendsAllowed] [int] NOT NULL,
[eFriendsPerGuest] [int] NOT NULL,
[eEventImageURL] [nvarchar](150) NOT NULL,
[eDateCreated] [datetime] NOT NULL,
[eDateModified] [datetime] NOT NULL,
[eInvitationImageKey] [int] NOT NULL,
CONSTRAINT [PK_e_InvitationDetails] PRIMARY KEY CLUSTERED
(
[eEventInvitationKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[e_InvitationCategory] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_InvitationCategory](
[eInvitationCategoryKey] [int] IDENTITY(1,1) NOT NULL,
[eInvitationCategory] [nvarchar](300) NOT NULL,
[eActive] [int] NOT NULL,
CONSTRAINT [PK_e_InvitationCategory] PRIMARY KEY CLUSTERED
(
[eInvitationCategoryKey] 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 IDENTITY_INSERT [dbo].[e_InvitationCategory] ON
INSERT [dbo].[e_InvitationCategory] ([eInvitationCategoryKey], [eInvitationCategory], [eActive]) VALUES (1, N'Birthday Party', 1)
INSERT [dbo].[e_InvitationCategory] ([eInvitationCategoryKey], [eInvitationCategory], [eActive]) VALUES (2, N'Christmas Party', 1)
INSERT [dbo].[e_InvitationCategory] ([eInvitationCategoryKey], [eInvitationCategory], [eActive]) VALUES (3, N'Dinner Party', 1)
INSERT [dbo].[e_InvitationCategory] ([eInvitationCategoryKey], [eInvitationCategory], [eActive]) VALUES (4, N'Farewell Party', 1)
INSERT [dbo].[e_InvitationCategory] ([eInvitationCategoryKey], [eInvitationCategory], [eActive]) VALUES (5, N'Freshers Party', 1)
INSERT [dbo].[e_InvitationCategory] ([eInvitationCategoryKey], [eInvitationCategory], [eActive]) VALUES (6, N'Graduation Party', 1)
INSERT [dbo].[e_InvitationCategory] ([eInvitationCategoryKey], [eInvitationCategory], [eActive]) VALUES (7, N'Halloween Party', 1)
INSERT [dbo].[e_InvitationCategory] ([eInvitationCategoryKey], [eInvitationCategory], [eActive]) VALUES (8, N'Lunch Party', 1)
INSERT [dbo].[e_InvitationCategory] ([eInvitationCategoryKey], [eInvitationCategory], [eActive]) VALUES (9, N'Thanksgiving Party', 1)
INSERT [dbo].[e_InvitationCategory] ([eInvitationCategoryKey], [eInvitationCategory], [eActive]) VALUES (10, N'Wedding Invitation', 1)
SET IDENTITY_INSERT [dbo].[e_InvitationCategory] OFF
/****** Object: Table [dbo].[pa_test] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[pa_test](
[paFirstName] [nvarchar](50) NOT NULL,
[paLastName] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
INSERT [dbo].[pa_test] ([paFirstName], [paLastName]) VALUES (N'simmer', N'singh')
/****** Object: Table [dbo].[e_StateCode] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_StateCode](
[eStateCodeKey] [int] IDENTITY(1,1) NOT NULL,
[eStateCode] [nvarchar](50) NOT NULL,
[eStateName] [nvarchar](50) NOT NULL,
[eActive] [nchar](10) NOT NULL,
CONSTRAINT [PK_e_StateCode] PRIMARY KEY CLUSTERED
(
[eStateCodeKey] 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 IDENTITY_INSERT [dbo].[e_StateCode] ON
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (1, N'AL', N'Alabama', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (2, N'AK', N'Alaska', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (3, N'AZ', N'Arizona', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (4, N'AR', N'Arkansas', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (5, N'CA', N'California', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (6, N'CO', N'Colorado', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (7, N'CT', N'Connecticut', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (8, N'DE', N'Delaware', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (9, N'DC', N'District of Columbia', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (10, N'FL', N'Florida', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (11, N'GA', N'Georgia', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (12, N'HI', N'Hawaii', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (13, N'ID', N'Idaho', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (14, N'IL', N'Illinois', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (15, N'IN', N'Indiana', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (16, N'IA', N'Iowa', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (17, N'KS', N'Kansas', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (18, N'KY', N'Kentucky', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (19, N'LA', N'Louisiana', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (20, N'ME', N'Maine', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (21, N'MD', N'Maryland', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (22, N'MA', N'Massachusetts', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (23, N'MI', N'Michigan', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (24, N'MN', N'Minnesota', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (25, N'MS', N'Mississippi', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (26, N'MO', N'Missouri', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (27, N'MT', N'Montana', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (28, N'NE', N'Nebraska', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (29, N'NV', N'Nevada', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (30, N'NH', N'New Hampshire', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (31, N'NJ', N'New Jersey', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (32, N'NM', N'New Mexico', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (33, N'NY', N'New York', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (34, N'NC', N'North Carolina', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (35, N'ND', N'North Dakota', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (36, N'OH', N'Ohio', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (37, N'OK', N'Oklahoma', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (38, N'OR', N'Oregon', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (39, N'PA', N'Pennsylvania', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (40, N'RI', N'Rhode Island', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (41, N'SC', N'South Carolina', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (42, N'SD', N'South Dakota', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (43, N'TN', N'Tennessee', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (44, N'TX', N'Texas', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (45, N'UT', N'Utah', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (46, N'VT', N'Vermont', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (47, N'VA', N'Virginia', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (48, N'WA', N'Washington', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (49, N'WV', N'West Virginia', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (50, N'WI', N'Wisconsin', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (51, N'WY', N'Wyoming', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (52, N'ON', N'Ontario', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (53, N'QC', N'Quebec', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (54, N'BC', N'British Columbia', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (55, N'AB', N'Alberta', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (56, N'MB', N'Manitoba', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (57, N'NB', N'New Brunswick', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (58, N'NL', N'Newfoundland and Labrador', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (59, N'NT', N'Northwest Territories', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (60, N'NS', N'Nova Scotia', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (61, N'NU', N'Nunavut', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (62, N'PE', N'Prince Edward Island', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (63, N'SK', N'Saskatchewan', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (64, N'YT', N'Yukon', N'1 ')
INSERT [dbo].[e_StateCode] ([eStateCodeKey], [eStateCode], [eStateName], [eActive]) VALUES (65, N'PR', N'Puerto Rico', N'1 ')
SET IDENTITY_INSERT [dbo].[e_StateCode] OFF
/****** Object: Table [dbo].[e_SecurityQuestion] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_SecurityQuestion](
[eSecurityQuestionKey] [int] IDENTITY(1,1) NOT NULL,
[eSecurityQuestion] [nvarchar](150) NOT NULL,
CONSTRAINT [PK_e_SecurityQuestion] PRIMARY KEY CLUSTERED
(
[eSecurityQuestionKey] 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 IDENTITY_INSERT [dbo].[e_SecurityQuestion] ON
INSERT [dbo].[e_SecurityQuestion] ([eSecurityQuestionKey], [eSecurityQuestion]) VALUES (1, N'What is your Pet''s Name ?')
INSERT [dbo].[e_SecurityQuestion] ([eSecurityQuestionKey], [eSecurityQuestion]) VALUES (2, N'What is your School Name ?')
INSERT [dbo].[e_SecurityQuestion] ([eSecurityQuestionKey], [eSecurityQuestion]) VALUES (3, N'What is your Mother''s Maiden Name ?')
INSERT [dbo].[e_SecurityQuestion] ([eSecurityQuestionKey], [eSecurityQuestion]) VALUES (4, N'Which City you are born in ?')
SET IDENTITY_INSERT [dbo].[e_SecurityQuestion] OFF
/****** Object: Table [dbo].[e_Login] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_Login](
[eLoginKey] [int] IDENTITY(1,1) NOT NULL,
[eFirstName] [nvarchar](50) NOT NULL,
[eLastName] [nvarchar](50) NOT NULL,
[eEmail] [nvarchar](50) NOT NULL,
[eUsername] [nvarchar](50) NOT NULL,
[ePassword] [nvarchar](50) NOT NULL,
[eSecurityQuestionKey] [int] NOT NULL,
[eSecurityAnswer] [nvarchar](50) NOT NULL,
[eDateCreated] [datetime] NOT NULL,
[eDateModified] [datetime] NOT NULL,
[eStatus] [int] NOT NULL,
[eAccountType] [int] NOT NULL,
CONSTRAINT [PK_e_Login] PRIMARY KEY CLUSTERED
(
[eLoginKey] 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 IDENTITY_INSERT [dbo].[e_Login] ON
INSERT [dbo].[e_Login] ([eLoginKey], [eFirstName], [eLastName], [eEmail], [eUsername], [ePassword], [eSecurityQuestionKey], [eSecurityAnswer], [eDateCreated], [eDateModified], [eStatus], [eAccountType]) VALUES (2, N'simmerdeep', N'singh', N'simmer.virk@gmail.com', N'simmerdeep', N'simmer3', 1, N'dog', CAST(0x00009FB0010094EA AS DateTime), CAST(0x00009FBE010ABF72 AS DateTime), 0, 2)
INSERT [dbo].[e_Login] ([eLoginKey], [eFirstName], [eLastName], [eEmail], [eUsername], [ePassword], [eSecurityQuestionKey], [eSecurityAnswer], [eDateCreated], [eDateModified], [eStatus], [eAccountType]) VALUES (3, N'sam', N'george', N'sam@gmail.com', N'sam', N'sam', 2, N'SDSU', CAST(0x00009FB001038A9A AS DateTime), CAST(0x00009FB001038AEA AS DateTime), 0, 2)
INSERT [dbo].[e_Login] ([eLoginKey], [eFirstName], [eLastName], [eEmail], [eUsername], [ePassword], [eSecurityQuestionKey], [eSecurityAnswer], [eDateCreated], [eDateModified], [eStatus], [eAccountType]) VALUES (4, N'sdsu', N'admin', N'virk.simmer@gmail.com', N'administrator', N'administrator', 1, N'dog', CAST(0x00009FC400D84BA0 AS DateTime), CAST(0x00009FC400D84BA0 AS DateTime), 0, 1)
SET IDENTITY_INSERT [dbo].[e_Login] OFF
/****** Object: Table [dbo].[e_InvitationImageDetails] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_InvitationImageDetails](
[eInvitationImageKey] [int] IDENTITY(1,1) NOT NULL,
[eInvitationImageName] [nvarchar](300) NOT NULL,
[eInvitationCategoryKey] [int] NOT NULL,
[eInvitationImageUploadedBy] [int] NOT NULL,
CONSTRAINT [PK_e_InvitationImageDetails] PRIMARY KEY CLUSTERED
(
[eInvitationImageKey] 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 IDENTITY_INSERT [dbo].[e_InvitationImageDetails] ON
INSERT [dbo].[e_InvitationImageDetails] ([eInvitationImageKey], [eInvitationImageName], [eInvitationCategoryKey], [eInvitationImageUploadedBy]) VALUES (1, N'BirthdayInvitation1.jpg', 1, 1)
INSERT [dbo].[e_InvitationImageDetails] ([eInvitationImageKey], [eInvitationImageName], [eInvitationCategoryKey], [eInvitationImageUploadedBy]) VALUES (2, N'BirthdayInvitation2.jpg', 1, 1)
INSERT [dbo].[e_InvitationImageDetails] ([eInvitationImageKey], [eInvitationImageName], [eInvitationCategoryKey], [eInvitationImageUploadedBy]) VALUES (3, N'BirthdayInvitation3.jpg', 1, 1)
INSERT [dbo].[e_InvitationImageDetails] ([eInvitationImageKey], [eInvitationImageName], [eInvitationCategoryKey], [eInvitationImageUploadedBy]) VALUES (4, N'BirthdayInvitation4.jpg', 1, 1)
INSERT [dbo].[e_InvitationImageDetails] ([eInvitationImageKey], [eInvitationImageName], [eInvitationCategoryKey], [eInvitationImageUploadedBy]) VALUES (5, N'BirthdayInvitation5.jpg', 1, 1)
INSERT [dbo].[e_InvitationImageDetails] ([eInvitationImageKey], [eInvitationImageName], [eInvitationCategoryKey], [eInvitationImageUploadedBy]) VALUES (6, N'BirthdayInvitation6.jpg', 1, 1)
INSERT [dbo].[e_InvitationImageDetails] ([eInvitationImageKey], [eInvitationImageName], [eInvitationCategoryKey], [eInvitationImageUploadedBy]) VALUES (7, N'ChristmasInvitation1.jpg', 2, 2)
SET IDENTITY_INSERT [dbo].[e_InvitationImageDetails] OFF
/****** Object: Table [dbo].[e_LoginContacts] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_LoginContacts](
[eContactKey] [int] IDENTITY(1,1) NOT NULL,
[eLoginKey] [int] NOT NULL,
[eContactFirstName] [nvarchar](50) NOT NULL,
[eContactLastName] [nvarchar](50) NOT NULL,
[eContactEmail] [nvarchar](50) NOT NULL,
[eContactDateCreated] [datetime] NOT NULL,
[eContactDateModified] [datetime] NOT NULL,
CONSTRAINT [PK_e_LoginContacts] PRIMARY KEY CLUSTERED
(
[eContactKey] 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 IDENTITY_INSERT [dbo].[e_LoginContacts] ON
INSERT [dbo].[e_LoginContacts] ([eContactKey], [eLoginKey], [eContactFirstName], [eContactLastName], [eContactEmail], [eContactDateCreated], [eContactDateModified]) VALUES (1, 2, N'Aman', N'Singh', N'aman@gmail.com', CAST(0x00009FB6017222BD AS DateTime), CAST(0x00009FB6017222BD AS DateTime))
INSERT [dbo].[e_LoginContacts] ([eContactKey], [eLoginKey], [eContactFirstName], [eContactLastName], [eContactEmail], [eContactDateCreated], [eContactDateModified]) VALUES (2, 2, N'Aman', N'Virk', N'amanvirk@gmail.com', CAST(0x00009FB801646585 AS DateTime), CAST(0x00009FB9016A4C15 AS DateTime))
INSERT [dbo].[e_LoginContacts] ([eContactKey], [eLoginKey], [eContactFirstName], [eContactLastName], [eContactEmail], [eContactDateCreated], [eContactDateModified]) VALUES (3, 2, N'Hitesh', N'Chaudhary', N'hiteshchaudhary78@gmail.com', CAST(0x00009FB9017032D0 AS DateTime), CAST(0x00009FB9017032D0 AS DateTime))
SET IDENTITY_INSERT [dbo].[e_LoginContacts] OFF
/****** Object: Table [dbo].[e_GuestInfo] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_GuestInfo](
[eGuestKey] [uniqueidentifier] NOT NULL,
[eEventInvitationKey] [int] NOT NULL,
[eGuestFirstName] [nvarchar](50) NOT NULL,
[eGuestLastName] [nvarchar](50) NOT NULL,
[eGuestEmail] [nvarchar](50) NOT NULL,
[eGuestStatus] [int] NOT NULL,
[eFriendCount] [int] NOT NULL,
[eDateCreated] [datetime] NOT NULL,
[eDateModified] [datetime] NOT NULL,
CONSTRAINT [PK_e_GuestInfo_1] PRIMARY KEY CLUSTERED
(
[eGuestKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[e_CardImageDetails] Script Date: 05/06/2012 12:59:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[e_CardImageDetails](
[eCardImageKey] [int] IDENTITY(1,1) NOT NULL,
[eCardImageName] [nvarchar](300) NOT NULL,
[eCardCategoryKey] [int] NOT NULL,
[eCardImageUploadedBy] [int] NOT NULL,
CONSTRAINT [PK_e_CardDetails] PRIMARY KEY CLUSTERED
(
[eCardImageKey] 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 IDENTITY_INSERT [dbo].[e_CardImageDetails] ON
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (1, N'BirthdayCard1.jpg', 2, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (2, N'BirthdayCard2.jpg', 2, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (3, N'BirthdayCard3.jpg', 2, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (4, N'BirthdayCard4.jpg', 2, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (5, N'BirthdayCard5.jpg', 2, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (6, N'BirthdayCard6.jpg', 2, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (7, N'AnniversaryCard1.jpg', 1, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (8, N'AnniversaryCard2.jpg', 1, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (9, N'AnniversaryCard3.jpg', 1, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (10, N'AnniversaryCard4.jpg', 1, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (11, N'AnniversaryCard5.jpg', 1, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (12, N'AnniversaryCard6.jpg', 1, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (13, N'ChristmasCard1.jpg', 3, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (14, N'ChristmasCard2.jpg', 3, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (15, N'ChristmasCard3.jpg', 3, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (16, N'ChristmasCard4.jpg', 3, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (17, N'ChristmasCard5.jpg', 3, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (18, N'ChristmasCard6.jpg', 3, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (19, N'CongratulationsCard1.jpg', 4, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (20, N'CongratulationsCard2.jpg', 4, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (21, N'CongratulationsCard3.jpg', 4, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (22, N'CongratulationsCard4.jpg', 4, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (23, N'CongratulationsCard5.jpg', 4, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (24, N'CongratulationsCard6.jpg', 4, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (25, N'FriendshipCard1.jpg', 5, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (26, N'FriendshipCard2.jpg', 5, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (27, N'FriendshipCard3.jpg', 5, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (28, N'FriendshipCard4.jpg', 5, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (29, N'FriendshipCard5.jpg', 5, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (30, N'FriendshipCard6.jpg', 5, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (31, N'GraduationCard1.jpg', 6, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (32, N'GraduationCard2.jpg', 6, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (33, N'GraduationCard3.jpg', 6, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (34, N'GraduationCard4.jpg', 6, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (35, N'GraduationCard5.jpg', 6, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (36, N'GraduationCard6.jpg', 6, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (37, N'HalloweenCard1.jpg', 7, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (38, N'HalloweenCard2.jpg', 7, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (39, N'HalloweenCard3.jpg', 7, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (40, N'HalloweenCard4.jpg', 7, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (41, N'HalloweenCard5.jpg', 7, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (42, N'HalloweenCard6.jpg', 7, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (43, N'ValentineCard1.jpg', 8, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (44, N'ValentineCard2.jpg', 8, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (45, N'ValentineCard3.jpg', 8, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (46, N'ValentineCard4.jpg', 8, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (47, N'ValentineCard5.jpg', 8, 1)
INSERT [dbo].[e_CardImageDetails] ([eCardImageKey], [eCardImageName], [eCardCategoryKey], [eCardImageUploadedBy]) VALUES (48, N'ValentineCard6.jpg', 8, 1)
SET IDENTITY_INSERT [dbo].[e_CardImageDetails] OFF
/****** Object: Default [DF_e_CardCategory_eCardCategory] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_CardCategory] ADD CONSTRAINT [DF_e_CardCategory_eCardCategory] DEFAULT ('') FOR [eCardCategory]
GO
/****** Object: Default [DF_e_CardCategory_eActive] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_CardCategory] ADD CONSTRAINT [DF_e_CardCategory_eActive] DEFAULT ((1)) FOR [eActive]
GO
/****** Object: Default [DF_e_InvitationDetails_eEventTitle] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_e_InvitationDetails_eEventTitle] DEFAULT ('') FOR [eEventTitle]
GO
/****** Object: Default [DF_e_InvitationDetails_eEventHostName] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_e_InvitationDetails_eEventHostName] DEFAULT ('') FOR [eEventHostName]
GO
/****** Object: Default [DF_Table_1_eEventContact] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_Table_1_eEventContact] DEFAULT ('') FOR [eEventHostContact]
GO
/****** Object: Default [DF_e_InvitationDetails_eEventTime] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_e_InvitationDetails_eEventTime] DEFAULT ('') FOR [eEventTime]
GO
/****** Object: Default [DF_e_InvitationDetails_eEventampm] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_e_InvitationDetails_eEventampm] DEFAULT ('') FOR [eEventampm]
GO
/****** Object: Default [DF_Table_1_eEventAddress] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_Table_1_eEventAddress] DEFAULT ('') FOR [eEventAddress1]
GO
/****** Object: Default [DF_e_InvitationDetails_eEventAddress2] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_e_InvitationDetails_eEventAddress2] DEFAULT ('') FOR [eEventAddress2]
GO
/****** Object: Default [DF_e_InvitationDetails_eEventCity] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_e_InvitationDetails_eEventCity] DEFAULT ('') FOR [eEventCity]
GO
/****** Object: Default [DF_e_InvitationDetails_eEventProvince] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_e_InvitationDetails_eEventProvince] DEFAULT ('') FOR [eEventProvince]
GO
/****** Object: Default [DF_e_InvitationDetails_eEventZip] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_e_InvitationDetails_eEventZip] DEFAULT ('') FOR [eEventZip]
GO
/****** Object: Default [DF_Table_1_eEventInvitationMessage] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_Table_1_eEventInvitationMessage] DEFAULT ('') FOR [eInvitationMessage]
GO
/****** Object: Default [DF_e_InvitationDetails_eEventStatus] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_e_InvitationDetails_eEventStatus] DEFAULT ((0)) FOR [eEventStatus]
GO
/****** Object: Default [DF_e_InvitationDetails_eFriendsPerGuest] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_e_InvitationDetails_eFriendsPerGuest] DEFAULT ((0)) FOR [eFriendsPerGuest]
GO
/****** Object: Default [DF_e_InvitationDetails_eEventImageURL] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationDetails] ADD CONSTRAINT [DF_e_InvitationDetails_eEventImageURL] DEFAULT ('') FOR [eEventImageURL]
GO
/****** Object: Default [DF_e_InvitationCategory_eInvitationCategory] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationCategory] ADD CONSTRAINT [DF_e_InvitationCategory_eInvitationCategory] DEFAULT ('') FOR [eInvitationCategory]
GO
/****** Object: Default [DF_e_InvitationCategory_eActive] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationCategory] ADD CONSTRAINT [DF_e_InvitationCategory_eActive] DEFAULT ((1)) FOR [eActive]
GO
/****** Object: Default [DF_e_StateCode_eStateCode] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_StateCode] ADD CONSTRAINT [DF_e_StateCode_eStateCode] DEFAULT ('') FOR [eStateCode]
GO
/****** Object: Default [DF_e_StateCode_eStateName] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_StateCode] ADD CONSTRAINT [DF_e_StateCode_eStateName] DEFAULT ('') FOR [eStateName]
GO
/****** Object: Default [DF_e_SecurityQuestion_paSecurityQuestion] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_SecurityQuestion] ADD CONSTRAINT [DF_e_SecurityQuestion_paSecurityQuestion] DEFAULT ('') FOR [eSecurityQuestion]
GO
/****** Object: Default [DF_e_Login_paFirstName] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_Login] ADD CONSTRAINT [DF_e_Login_paFirstName] DEFAULT ('') FOR [eFirstName]
GO
/****** Object: Default [DF_e_Login_paLastName] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_Login] ADD CONSTRAINT [DF_e_Login_paLastName] DEFAULT ('') FOR [eLastName]
GO
/****** Object: Default [DF_e_Login_paEmail] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_Login] ADD CONSTRAINT [DF_e_Login_paEmail] DEFAULT ('') FOR [eEmail]
GO
/****** Object: Default [DF_e_Login_paUsername] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_Login] ADD CONSTRAINT [DF_e_Login_paUsername] DEFAULT ('') FOR [eUsername]
GO
/****** Object: Default [DF_e_Login_paPassword] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_Login] ADD CONSTRAINT [DF_e_Login_paPassword] DEFAULT ('') FOR [ePassword]
GO
/****** Object: Default [DF_e_Login_paAnswer] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_Login] ADD CONSTRAINT [DF_e_Login_paAnswer] DEFAULT ('') FOR [eSecurityAnswer]
GO
/****** Object: Default [DF_e_Login_eAccountType] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_Login] ADD CONSTRAINT [DF_e_Login_eAccountType] DEFAULT ((0)) FOR [eAccountType]
GO
/****** Object: Default [DF_e_InvitationImageDetails_eInvitationImageUploadedBy] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationImageDetails] ADD CONSTRAINT [DF_e_InvitationImageDetails_eInvitationImageUploadedBy] DEFAULT ((1)) FOR [eInvitationImageUploadedBy]
GO
/****** Object: Default [DF_e_LoginContacts_eContactFirstName] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_LoginContacts] ADD CONSTRAINT [DF_e_LoginContacts_eContactFirstName] DEFAULT ('') FOR [eContactFirstName]
GO
/****** Object: Default [DF_e_LoginContacts_eContactLastName] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_LoginContacts] ADD CONSTRAINT [DF_e_LoginContacts_eContactLastName] DEFAULT ('') FOR [eContactLastName]
GO
/****** Object: Default [DF_e_LoginContacts_eContactEmail] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_LoginContacts] ADD CONSTRAINT [DF_e_LoginContacts_eContactEmail] DEFAULT ('') FOR [eContactEmail]
GO
/****** Object: Default [DF_e_GuestInfo_eGuestFirstName] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_GuestInfo] ADD CONSTRAINT [DF_e_GuestInfo_eGuestFirstName] DEFAULT ('') FOR [eGuestFirstName]
GO
/****** Object: Default [DF_e_GuestInfo_eGuestLastName] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_GuestInfo] ADD CONSTRAINT [DF_e_GuestInfo_eGuestLastName] DEFAULT ('') FOR [eGuestLastName]
GO
/****** Object: Default [DF_e_GuestInfo_eGuestEmail] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_GuestInfo] ADD CONSTRAINT [DF_e_GuestInfo_eGuestEmail] DEFAULT ('') FOR [eGuestEmail]
GO
/****** Object: Default [DF_e_GuestInfo_eFriendCount] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_GuestInfo] ADD CONSTRAINT [DF_e_GuestInfo_eFriendCount] DEFAULT ((0)) FOR [eFriendCount]
GO
/****** Object: Default [DF_e_CardDetails_eCardName] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_CardImageDetails] ADD CONSTRAINT [DF_e_CardDetails_eCardName] DEFAULT ('') FOR [eCardImageName]
GO
/****** Object: Default [DF_e_CardImageDetails_eCardUploadedBy] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_CardImageDetails] ADD CONSTRAINT [DF_e_CardImageDetails_eCardUploadedBy] DEFAULT ((1)) FOR [eCardImageUploadedBy]
GO
/****** Object: ForeignKey [FK_e_InvitationImageDetails_e_InvitationCategory] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_InvitationImageDetails] WITH CHECK ADD CONSTRAINT [FK_e_InvitationImageDetails_e_InvitationCategory] FOREIGN KEY([eInvitationCategoryKey])
REFERENCES [dbo].[e_InvitationCategory] ([eInvitationCategoryKey])
GO
ALTER TABLE [dbo].[e_InvitationImageDetails] CHECK CONSTRAINT [FK_e_InvitationImageDetails_e_InvitationCategory]
GO
/****** Object: ForeignKey [FK_e_LoginContacts_e_Login] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_LoginContacts] WITH CHECK ADD CONSTRAINT [FK_e_LoginContacts_e_Login] FOREIGN KEY([eLoginKey])
REFERENCES [dbo].[e_Login] ([eLoginKey])
GO
ALTER TABLE [dbo].[e_LoginContacts] CHECK CONSTRAINT [FK_e_LoginContacts_e_Login]
GO
/****** Object: ForeignKey [FK_e_GuestInfo_e_GuestInfo] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_GuestInfo] WITH CHECK ADD CONSTRAINT [FK_e_GuestInfo_e_GuestInfo] FOREIGN KEY([eEventInvitationKey])
REFERENCES [dbo].[e_InvitationDetails] ([eEventInvitationKey])
GO
ALTER TABLE [dbo].[e_GuestInfo] CHECK CONSTRAINT [FK_e_GuestInfo_e_GuestInfo]
GO
/****** Object: ForeignKey [FK_e_CardImageDetails_e_CardCategory] Script Date: 05/06/2012 12:59:00 ******/
ALTER TABLE [dbo].[e_CardImageDetails] WITH CHECK ADD CONSTRAINT [FK_e_CardImageDetails_e_CardCategory] FOREIGN KEY([eCardCategoryKey])
REFERENCES [dbo].[e_CardCategory] ([eCardCategoryKey])
GO
ALTER TABLE [dbo].[e_CardImageDetails] CHECK CONSTRAINT [FK_e_CardImageDetails_e_CardCategory]
GO




The first error I get is
Msg 5133, Level 16, State 1, Line 2
Directory lookup for the file "D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\evite.mdf" failed with the operating system error 21(The device is not ready.).

I dont think so I have this folder called MSSQL10.MSSQLSERVER. Do I have to change path ????

please help me in setting this up.

Thanks.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts
Posted - 2012-09-22 : 19:00:00
That error is because you don't have the path shown in red below. That is where it is trying to create the data and log files for the database. Change those paths to where you want the data and log files to reside on the new system.

If you want to move the data along with the database (at least some of which you seem to be doing), another way would be to backup the database on your old laptop and then restore it on to the new system (where you will again need to indicate where the files should go).

USE [master]
GO
/****** Object: Database [evite] Script Date: 05/06/2012 12:58:56 ******/
CREATE DATABASE [evite] ON PRIMARY 
( NAME = N'evite', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\evite.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON 
( NAME = N'evite_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\evite_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [evite] SET COMPATIBILITY_LEVEL = 100
GO
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2012-09-22 : 23:32:00
you could simply use SQL management studio wizard to create database in new machine after copying mdf and ldf to suitable folders. Just browse to required files from wizard and it will create database from the wizard using the mdf,ldf files

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site