How can we help you today? How can we help you today?
kewlgeek

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...
0 votes
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...
2 followers 3 comments 0 votes