Install S-Office Application
Install script version E:\VARSG-Office\Providers\DataProviders\SqlDataProvider\00.02.00.SqlDataProvider
Quá trình cài đặt không thành công, có lỗi xảy ra trong quá trình cài đặt
System.Data.SqlClient.SqlException: Could not drop object 'dbo.Core_Users' because it is referenced by a FOREIGN KEY constraint.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
at VSS.Core.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Core_Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Core_Users]
System.Data.SqlClient.SqlException: There is already an object named 'Core_Users' in the database.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
at VSS.Core.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE TABLE [dbo].[Core_Users] (
[UserID] [int] IDENTITY (1, 1) NOT NULL ,
[GroupID] [int] NULL ,
[FirstName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[LastName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Street] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[City] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[District] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Country] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Title] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Telephone] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Mobile] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UserName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Password] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Authorized] [bit] NULL ,
[LastLoginDate] [datetime] NULL ,
[CreatedDate] [datetime] NULL ,
[DisableUsingMailModule] [bit] NULL ,
[IsDeleted] [bit] NULL
) ON [PRIMARY]