myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Query Error in Database Options · View
juboe
Posted: Tuesday, January 26, 2010 2:50:23 AM
Rank: Newbie
Groups: Member

Joined: 11/6/2009
Posts: 1
Points: 3
Location: United States
I have SQL database for Server 2008 through my hosting company. I finally figured out how to upload database script to the database and run it.

I went to Tools>New Query> and pasted the script that I had copied into Notepad. I get the following errors all the way through the completed query. I have just gotten started with this stuff. I have a login to the website to protect a directory. There are only 5 or 6 user entries so far. I have been trying to get this to work and know very little about databases.

#1 Are there any tutorials?
#2 Here is the results after I submit the pasted script from the database:

Changed database context to 'DB_2a2039'.


/****** Object: Default [DF__aspnet_Ap__Appli__08EA5793] Script Date: 01/24/2010 18:25:02 ******/
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Ap__Appli__08EA5793]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Applications]'))
Begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__aspnet_Ap__Appli__08EA5793]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[aspnet_Applications] DROP CONSTRAINT [DF__aspnet_Ap__Appli__08EA5793]
END


End
Msg 4902, Level 16, State 1, Line number 6
Cannot find the object "dbo.aspnet_Applications" because it does not exist or you do not have permissions.


/****** Object: Default [DF__aspnet_Me__Passw__239E4DCF] Script Date: 01/24/2010 18:25:02 ******/
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Me__Passw__239E4DCF]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]'))
Begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__aspnet_Me__Passw__239E4DCF]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [DF__aspnet_Me__Passw__239E4DCF]
END


End
Msg 4902, Level 16, State 1, Line number 6
Cannot find the object "dbo.aspnet_Membership" because it does not exist or you do not have permissions.


/****** Object: Default [DF__aspnet_Pa__PathI__5BE2A6F2] Script Date: 01/24/2010 18:25:02 ******/
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Pa__PathI__5BE2A6F2]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]'))
Begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__aspnet_Pa__PathI__5BE2A6F2]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [DF__aspnet_Pa__PathI__5BE2A6F2]
END


End
Msg 4902, Level 16, State 1, Line number 6
Cannot find the object "dbo.aspnet_Paths" because it does not exist or you do not have permissions.


/****** Object: Default [DF__aspnet_Perso__Id__6754599E] Script Date: 01/24/2010 18:25:02 ******/
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Perso__Id__6754599E]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]'))
Begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__aspnet_Perso__Id__6754599E]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [DF__aspnet_Perso__Id__6754599E]
END


End
Msg 4902, Level 16, State 1, Line number 6
Cannot find the object "dbo.aspnet_PersonalizationPerUser" because it does not exist or you do not have permissions.


/****** Object: Default [DF__aspnet_Ro__RoleI__44FF419A] Script Date: 01/24/2010 18:25:02 ******/
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Ro__RoleI__44FF419A]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]'))
Begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__aspnet_Ro__RoleI__44FF419A]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT [DF__aspnet_Ro__RoleI__44FF419A]
END


End
Msg 4902, Level 16, State 1, Line number 6
Cannot find the object "dbo.aspnet_Roles" because it does not exist or you do not have permissions.


/****** Object: Default [DF__aspnet_Us__UserI__0EA330E9] Script Date: 01/24/2010 18:25:02 ******/
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__UserI__0EA330E9]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]'))
Begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__aspnet_Us__UserI__0EA330E9]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__UserI__0EA330E9]
END


End
Msg 4902, Level 16, State 1, Line number 6
Cannot find the object "dbo.aspnet_Users" because it does not exist or you do not have permissions.


/****** Object: Default [DF__aspnet_Us__Mobil__0F975522] Script Date: 01/24/2010 18:25:02 ******/
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__Mobil__0F975522]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]'))
Begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__aspnet_Us__Mobil__0F975522]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__Mobil__0F975522]
END


End
Msg 4902, Level 16, State 1, Line number 6
Cannot find the object "dbo.aspnet_Users" because it does not exist or you do not have permissions.


/****** Object: Default [DF__aspnet_Us__IsAno__108B795B] Script Date: 01/24/2010 18:25:02 ******/
IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__IsAno__108B795B]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]'))
Begin
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__aspnet_Us__IsAno__108B795B]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__IsAno__108B795B]
END


End
Msg 4902, Level 16, State 1, Line number 6
Cannot find the object "dbo.aspnet_Users" because it does not exist or you do not have permissions.


I wonder if this has anything to do with the permissions that I set with the few users that I have created????

Thanks,
Juboe
elian
Posted: Tuesday, January 26, 2010 4:54:56 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Your query refers to the table dbo.aspnet_Applications that apparently does not exist in the db.
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another Forum.net version 1.9.1.8 (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.