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