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
|
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.
|