Torna al Thread

/****** Object: ForeignKey [FK__aspnet_Me__Appli__1A9EF37A] Script Date: 09/13/2012 12:37:41 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__Appli__1A9EF37A]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]')) ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__Appli__1A9EF37A] Msg 4902, Livello 16, Stato 1, Numero Riga 3 Cannot find the object "dbo.aspnet_Membership" because it does not exist or you do not have permissions. /****** Object: ForeignKey [FK_tbPagine_tbPagineRighe] Script Date: 09/13/2012 12:37:42 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tbPagine_tbPagineRighe]') AND parent_object_id = OBJECT_ID(N'[dbo].[tbPagine]')) ALTER TABLE [dbo].[tbPagine] DROP CONSTRAINT [FK_tbPagine_tbPagineRighe] Msg 229, Livello 14, Stato 5, Numero Riga 2 The SELECT permission was denied on the object 'foreign_keys', database 'mssqlsystemresource', schema 'sys'. IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbPagineParagrafi]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[tbPagineParagrafi]( [IDPagineParagrafi] [bigint] IDENTITY(1,1) NOT NULL, [IDPagine] [bigint] NOT NULL, [Sigla_l1] [nvarchar](20) NOT NULL, [Sigla_l2] [nvarchar](20) NULL, [Sigla_l3] [nvarchar](20) NULL, [Sigla_l4] [nvarchar](20) NULL, [Titolo_l1] [nvarchar](255) NULL, [Titolo_l2] [nvarchar](255) NULL, [Titolo_l3] [nvarchar](255) NULL, [Titolo_l4] [nvarchar](255) NULL, [OrdineVis] [bigint] NULL, [Disabilitato] [bit] NULL, [DataCreaz] [datetime] NULL, [DataUltAgg] [datetime] NULL, CONSTRAINT [PK_tbPagineParagrafi] PRIMARY KEY CLUSTERED ( [IDPagineParagrafi] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END Msg 229, Livello 14, Stato 5, Numero Riga 1 The SELECT permission was denied on the object 'objects', database 'mssqlsystemresource', schema 'sys'.
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5