Aug 17, 2006
I have this CD that has a database called Contacts on it and everytime I try to insatll it I get the same errors. I'm trying to install it from the D: driveThis is what is to be ran in Query Analyzer
/****** Object:
Database Contacts Script Date:
3/7/2002 1:52:44 PM ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE
name = N'Contacts')
DROP
DATABASE [Contacts]
GO
CREATE DATABASE [Contacts]
ON (NAME = N'Contacts_Data', FILENAME = N'MCSDWebAppschapter05Contacts.MDF'
, SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Contacts_Log', FILENAME =
N'MCSDWebAppschapter05Contacts.LDF' , SIZE = 1, FILEGROWTH = 10%)
COLLATE
SQL_Latin1_General_CP1_CI_AS
GO
exec sp_dboption N'Contacts', N'autoclose', N'false'
GO
exec sp_dboption N'Contacts', N'bulkcopy', N'false'
GO
exec sp_dboption N'Contacts', N'trunc. log', N'false'
GO
exec sp_dboption N'Contacts', N'torn page detection',
N'true'
GO
exec sp_dboption N'Contacts', N'read only', N'false'
GO
exec sp_dboption N'Contacts', N'dbo use', N'false'
GO
exec sp_dboption N'Contacts', N'single', N'false'
GO
exec sp_dboption N'Contacts', N'autoshrink', N'false'
GO
exec sp_dboption N'Contacts', N'ANSI null default', N'false'
GO
exec sp_dboption N'Contacts', N'recursive triggers',
N'false'
GO
exec sp_dboption N'Contacts', N'ANSI nulls', N'false'
GO
exec sp_dboption N'Contacts', N'concat null yields null',
N'false'
GO
exec sp_dboption N'Contacts', N'cursor close on commit',
N'false'
GO
exec sp_dboption N'Contacts', N'default to local cursor',
N'false'
GO
exec sp_dboption N'Contacts', N'quoted identifier', N'false'
GO
exec sp_dboption N'Contacts', N'ANSI warnings', N'false'
GO
exec sp_dboption N'Contacts', N'auto create statistics',
N'true'
GO
exec sp_dboption N'Contacts', N'auto update statistics',
N'true'
GO
use [Contacts]
GO
/****** Object: Table
[dbo].[Calls] Script Date: 3/7/2002
1:52:49 PM ******/
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Calls]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Calls]
GO
/****** Object: Table
[dbo].[Contact Types] Script Date:
3/7/2002 1:52:49 PM ******/
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Contact Types]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Contact Types]
GO
/****** Object: Table
[dbo].[Contacts] Script Date: 3/7/2002
1:52:49 PM ******/
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Contacts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Contacts]
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
if not exists (select * from dbo.sysusers where name =
N'ASPNET' and uid < 16382)
EXEC
sp_grantdbaccess N'ASPNET', N'ASPNET'
GO
/****** Object: User
dbo Script Date: 3/7/2002 1:52:45 PM
******/
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_accessadmin', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_backupoperator', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_datareader', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_datawriter', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_ddladmin', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45 PM
******/
exec sp_addrolemember N'db_denydatareader', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_denydatawriter', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_owner', N'ASPNET'
GO
/****** Object: User
ASPNET Script Date: 3/7/2002 1:52:45
PM ******/
exec sp_addrolemember N'db_securityadmin', N'ASPNET'
GO
/****** Object: Table
[dbo].[Calls] Script Date: 3/7/2002
1:52:51 PM ******/
CREATE TABLE [dbo].[Calls] (
[CallID]
[int] NOT NULL ,
[ContactID]
[int] NOT NULL ,
[CallDate]
[datetime] NULL ,
[CallTime]
[datetime] NULL ,
[Subject]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Notes]
[ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table
[dbo].[Contact Types] Script Date:
3/7/2002 1:52:55 PM ******/
CREATE TABLE [dbo].[Contact Types] (
[ContactTypeID]
[int] NOT NULL ,
[ContactType]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
/****** Object: Table
[dbo].[Contacts] Script Date: 3/7/2002
1:52:55 PM ******/
CREATE TABLE [dbo].[Contacts] (
[ContactID]
[int] NOT NULL ,
[FirstName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LastName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Dear]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Address]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[City]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StateOrProvince]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PostalCode]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Region]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Country]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CompanyName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[WorkPhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[WorkExtension]
[nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[HomePhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MobilePhone]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FaxNumber]
[nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[EmailName]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Birthdate]
[smalldatetime] NULL ,
[LastMeetingDate]
[smalldatetime] NULL ,
[ContactTypeID]
[int] NULL ,
[ReferredBy]
[nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Notes]
[ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ContactsInterests]
[nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Calls] WITH NOCHECK ADD
CONSTRAINT
[PK__Calls__59063A47] PRIMARY KEY
CLUSTERED
(
[CallID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Contact Types] WITH NOCHECK ADD
CONSTRAINT
[PK__Contact Types__5AEE82B9] PRIMARY KEY
CLUSTERED
(
[ContactTypeID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Contacts] WITH NOCHECK ADD
CONSTRAINT
[PK__Contacts__5CD6CB2B] PRIMARY KEY
CLUSTERED
(
[ContactID]
) ON [PRIMARY]
GO
GRANT REFERENCES
, SELECT , UPDATE ,
INSERT , DELETE ON [dbo].[Calls] TO [ASPNET]
GO
GRANT REFERENCES
, SELECT , UPDATE ,
INSERT , DELETE ON [dbo].[Contact Types] TO [ASPNET]
GO
GRANT SELECT ON [dbo].[Contacts] TO [public]
GO
GRANT REFERENCES
, SELECT , UPDATE ,
INSERT , DELETE ON [dbo].[Contacts] TO [ASPNET]
GO
INSERT Contacts VALUES (1, 'Kim', 'Abercrombie', 'Ms.',
'1234 Lone Dr.', 'Mobile', 'AL', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1111', '999', '(111) 555-2222',NULL, NULL,'someone@microsoft.com'
, '8/3/1961', NULL, 1, NULL, NULL, 'Parasailing')
INSERT Contacts VALUES (2, 'Jay', 'Adams', 'Mr.', '631 Eagle
Rd.', 'Watertown', 'PA', '999999', NULL, 'USA', 'Fabrikam', NULL, '(111)
555-1112', '888', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'4/1/1942', NULL, 3, NULL, NULL, NULL)
INSERT Contacts VALUES (3, 'Adam', 'Bar', 'Mr.', '55
Passaway Ave.', 'Boston', 'MA', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1113', NULL, '(111) 555-2222',NULL, NULL,'someone@microsoft.com'
, '2/3/1965', NULL, 4, NULL, NULL, 'Fly fishing')
INSERT Contacts VALUES (4, 'Ido', 'Ben-Sachar', 'Mr.', '602A
Leeward Dr.', 'Sarasota', 'FL', '999999', NULL, 'USA', 'Wide World Importers',
NULL, '(111) 555-1114', '777', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '1/22/1960', NULL, 1, NULL, NULL, NULL)
INSERT Contacts VALUES (5, 'Bradley', 'Beck', 'Mr.', '44
Adams St.', 'Parkaway', 'NJ', '999999', NULL, 'USA', 'Adventure Works', NULL,
'(111) 555-1115', '333', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'9/30/1959', NULL, 2, NULL, NULL, NULL)
INSERT Contacts VALUES (6, 'Karen', 'Berge', 'Mrs.', '205
Lone Dr.', 'Mobile', 'AL', '999999', NULL, 'USA', 'Wide World Importers', NULL,
'(111) 555-1116', NULL, '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'6/7/1960', NULL, 3, NULL, NULL, 'Windsurfing')
INSERT Contacts VALUES (7, 'Scott', 'Bishop', 'Dr.', '8898
Lipshaw Blvd.', 'Paradise', 'OR', '999999', NULL, 'USA', 'Wide World
Importers', NULL, '(111) 555-1117', '555', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '11/23/1961', NULL, 1, NULL, NULL, NULL)
INSERT Contacts VALUES (8, 'Pat', 'Coleman', 'Ms.', 'Rte 3
Highway 99', 'Circle City', 'AZ', '999999', NULL, 'USA', 'Fabrikam', NULL,
'(111) 555-1118', '87', '(111) 555-2222',NULL, NULL,'someone@microsoft.com' ,
'10/13/1970', NULL, 2, NULL, NULL, 'Skiing')
INSERT Contacts VALUES (9, 'Jane', 'Clayton', 'Ms.', '2
Wyldflower Ln.', 'Boulder', 'CO', '999999', NULL, 'USA', 'Wide World
Importers', NULL, '(111) 555-1119', '22', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '5/4/1961', NULL, 3, NULL, NULL, 'Hunting')
INSERT Contacts VALUES (10, 'Kari', 'Hensien', 'Ms.', '43
Stormwater Cr.', 'Indialantic', 'FL', '999999', NULL, 'USA', 'Adventure Works',
NULL, '(111) 555-1110', '0988', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '7/7/1959', NULL, 1, NULL, NULL, NULL)
INSERT Contacts VALUES (11, 'Don', 'Funk', 'Mr.', '55
Moccasin Wallow Dr.', 'Ernst', 'FL', '999999', NULL, 'USA', 'Fourth Coffee',
NULL, '(111) 555-1120', '111', '(111) 555-2222',NULL,
NULL,'someone@microsoft.com' , '3/15/1966', NULL, 1, NULL, NULL, NULL)
INSERT "Contact Types" VALUES(1, 'Business')
INSERT "Contact Types" VALUES(2, 'Social')
INSERT "Contact Types" VALUES(3, 'Friend')
INSERT "Contact Types" VALUES(4, 'Fishing buddy')
INSERT Calls VALUES(1,1,'3/3/2002', '12:00PM', 'Hosting
services', 'Return call with estimates')
INSERT Calls VALUES(2,3,'3/3/2002', '1:00PM', 'Trip to
Azores', 'Got lost on way. Needs directions.')
INSERT Calls VALUES(3,2,'2/1/2002', '10:00AM', 'Long call',
'A very, very long call.')
THIS IS THE ERRORS I KEEP GETTING
Server: Msg 5105, Level 16, State 2, Line 2
Device activation error. The physical file name
'MCSDWebAppschapter05Contacts.MDF' may be incorrect.
Server: Msg 1802, Level 16, State 1, Line 2
CREATE DATABASE failed. Some file names listed could not be
created. Check previous errors.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 15010, Level 16, State 1, Procedure sp_dboption,
Line 70
The database 'Contacts' does not exist. Use sp_helpdb to
show available databases.
Server: Msg 911, Level 16, State 1, Line 2
Could not locate entry in sysdatabases for database
'Contacts'. No entry found with that name. Make sure that the name is entered
correctly.
Server: Msg 15007, Level 16, State 1, Procedure
sp_grantdbaccess, Line 97
The login 'ASPNET' does not exist.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 15410, Level 11, State 1, Procedure
sp_addrolemember, Line 66
User or role 'ASPNET' does not exist in this database.
Server: Msg 4604, Level 16, State 1, Line 2
There is no such user or group 'ASPNET'.
Server: Msg 4604, Level 16, State 1, Line 2
There is no such user or group 'ASPNET'.
Server: Msg 4604, Level 16, State 1, Line 2
There is no such user or group 'ASPNET'.
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
I JUST WANT TO KNOW WHAT I NEED TO DO STEP FOR STEPTHIS IS MY FIRST TIME ON THIS FORUMCAN ANYONE HELP ME OUT
View 2 Replies
View Related
