Activity overview
Latest activity by kewlgeek
Hi Michelle,
No, we are not using encrypted triggers. Here are the scripts:
CREATE TABLE [dbo].[AssignRolesToElementActions]
(
[AssignRolesTestGuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_AssignRolesTest_AssignRolesTestGuid] DEFAULT (newid()),
[ElementGuid] [uniqueidentifier] NOT NULL,
[SecurityRoleGuid] [uniqueidentifier] NOT NULL,
[ElementAction] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_AssignRolesTest_CreatedDate] DEFAULT (getdate()),
[LastUpdatedDate] [datetime] NOT NULL CONSTRAINT [DF_AssignRolesTest_LastUpdatedDate] DEFAULT (getdate()),
[UpdatedBy] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SysTransID] [smallint] NOT NULL CONSTRAINT [DF_AssignRolesTest_SysTransID] DEFAULT (0)
)
GO
and here is the second table:
CREATE TABLE [dbo].[AssignRolesToElementActions]
(
[AssignRolesTestGuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_AssignRolesTest_AssignRolesTestGuid] DEFAULT (newid()),
[ElementGuid] [uniqueidentifier] NOT NULL,
[SecurityRoleGuid] [uniqueidentifier] NOT NULL,
[ElementAction] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatedDate] [datetime] NOT NULL CONSTRAINT [DF_AssignRolesTest_CreatedDate] DEFAULT (getdate()),
[LastUpdatedDate] [datetime] NOT NULL CONSTRAINT [DF_AssignRolesTest_LastUpdatedDate] DEFAULT (getdate()),
[UpdatedBy] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SysTransID] [smallint] NOT NULL CONSTRAINT [DF_AssignRolesTest_SysTransID] DEFAULT ((0))
)
GO
Thanks,
Karin / comments
Hi Michelle,
No, we are not using encrypted triggers. Here are the scripts:
CREATE TABLE [dbo].[AssignRolesToElementActions]
(
[AssignRolesTestGuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Assig...
SQL Compare Showing Differences in Default Constraints
Hello,
SQL Compare 6 is showing differences between tables when the only thing different is the default constraint, which on one server is defined as (0) and on the other is ((0)). Even if I tell i...