How can we help you today? How can we help you today?
ccollins
Activity overview Badges (0) Posts (6) Comments (15)

Activity overview

Latest activity by ccollins

Description: A problem caused this program to stop interacting with Windows. Problem signature: Problem Event Name: AppHangB1 Application Name: Ssms.exe Application Version: 2009.100.1600.1 Application Timestamp: 4bb679e7 Hang Signature: 5d4e Hang Type: 6400 OS Version: 6.1.7600.2.0.0.256.1 Locale ID: 1033 Additional Hang Signature 1: 5d4e89e34b78d1eaec09604964415018 Additional Hang Signature 2: 7339 Additional Hang Signature 3: 7339e7c669c193a7ad276d15bf9f2609 Additional Hang Signature 4: 5d4e Additional Hang Signature 5: 5d4e89e34b78d1eaec09604964415018 Additional Hang Signature 6: 7339 Additional Hang Signature 7: 7339e7c669c193a7ad276d15bf9f2609 Read our privacy statement online: http://go.microsoft.com/fwlink/?linkid= ... cid=0x0409 If the online privacy statement is not available, please read our privacy statement offline: C:\Windows\system32\en-US\erofflps.txt / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Link Static Data - Takes 5 Minutes to Compare Databases
Description: A problem caused this program to stop interacting with Windows. Problem signature: Problem Event Name: AppHangB1 Application Name: Ssms.exe Application Version: 2009.100.1600.1 Applica...
0 votes
Dead After a Day. I had to end the SSMS process, no other method worked. I am going to attempt to add static linked tables in groups and check in. This may work around the check in issue, but probably not the get latest issue. This is a wall, not a speed bump. / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Link Static Data - Takes 5 Minutes to Compare Databases
Dead After a Day. I had to end the SSMS process, no other method worked. I am going to attempt to add static linked tables in groups and check in. This may work around the check in issue, but pro...
0 votes
Getting large recordset static linked data OutOfMemoryExcept
  1. Community
  2. SQL Source Control Previous Versions
SSRS 2008 R2 SSMS Static linked data table with 46K records. Committed fine. Getting changes on mine and other dev workstations failing with:System.OutOfMemoryException: Exception of type 'System.O...
1 follower 1 comment 0 votes
how to control Database Extended Properties
  1. Community
  2. SQL Source Control Previous Versions
Using SQL Source Control V2.1.0.31 I added a Version extended property at the Database level. I do not get the opportunity to check it in. However, I changed a table level extended property and ch...
1 follower 1 comment 0 votes
The scenario of two DLLs, named the same, but having different functionality and versions exists in Version 8 as well. This is not easily implemented in a distributed system. One dll or two dll names is requested. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Different Versions of dll's for SQLCompare and SQLDataCompar
The scenario of two DLLs, named the same, but having different functionality and versions exists in Version 8 as well. This is not easily implemented in a distributed system. One dll or two dll na...
0 votes
We are using SQL 2000 SP4 for production. However, we are seeing the same situation with the same databases on SQL 2005. I can supply two data set types: a) bulk loadable text files for each table b)synchronize script. I do not have a public internet server to link to, is there an attach or upload facility you provide? / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. nText and Text column comparision improvements required
We are using SQL 2000 SP4 for production. However, we are seeing the same situation with the same databases on SQL 2005. I can supply two data set types: a) bulk loadable text files for each tabl...
0 votes
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_EntityContent_ContentID_Content_ContentID]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[EntityContent] DROP CONSTRAINT FK_EntityContent_ContentID_Content_ContentID GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_EntityContent_VersionID_Version_VersionID]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[EntityContent] DROP CONSTRAINT FK_EntityContent_VersionID_Version_VersionID GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trgDbaInsContent]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trgDbaInsContent] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trgDbaUpdContent]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trgDbaUpdContent] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trgDbaDelContent]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trgDbaDelContent] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trgDbaInsVersion]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trgDbaInsVersion] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trgDbaUpdVersion]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trgDbaUpdVersion] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trgDbaDelVersion]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trgDbaDelVersion] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trgDbaInsEntityContent]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trgDbaInsEntityContent] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trgDbaUpdEntityContent]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trgDbaUpdEntityContent] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[trgDbaDelEntityContent]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [dbo].[trgDbaDelEntityContent] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EntityContent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[EntityContent] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Content]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Content] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Version]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Version] GO if exists (select * from dbo.systypes where name = N'XMLDATA') exec sp_droptype N'XMLDATA' GO setuser GO EXEC sp_addtype N'XMLDATA', N'ntext', N'not null' GO setuser GO CREATE TABLE [dbo].[Content] ( [ContentID] [int] NOT NULL , [ContentXML] [XMLDATA] NOT NULL , [RowID] [uniqueidentifier] NOT NULL , [dbaDateCreated] [datetime] NULL , [dbaDateUpdated] [datetime] NULL , [dbaIsActive] [tinyint] NULL , [dbaIsDeleted] [tinyint] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[Version] ( [VersionID] [int] NOT NULL , [VersionMajor] [int] NOT NULL , [VersionMinor] [int] NOT NULL , [VersionText] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DateInstalled] [datetime] NOT NULL , [EffectiveDate] [datetime] NOT NULL , [RowID] [uniqueidentifier] NOT NULL , [dbaDateCreated] [datetime] NULL , [dbaDateUpdated] [datetime] NULL , [dbaIsActive] [tinyint] NULL , [dbaIsDeleted] [tinyint] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[EntityContent] ( [EntityContentID] [int] NOT NULL , [EntityGUID] [uniqueidentifier] NOT NULL , [VersionID] [int] NOT NULL , [ContentID] [int] NOT NULL , [RowID] [uniqueidentifier] NOT NULL , [dbaDateCreated] [datetime] NULL , [dbaDateUpdated] [datetime] NULL , [dbaIsActive] [tinyint] NULL , [dbaIsDeleted] [tinyint] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[Content] ADD CONSTRAINT [DF_Content_RowID] DEFAULT (newid()) FOR [RowID], CONSTRAINT [DF_Content_dbaDateCreated] DEFAULT (convert(nchar(19),getutcdate(),121)) FOR [dbaDateCreated], CONSTRAINT [DF_Content_dbaDateUpdated] DEFAULT (convert(nchar(19),getutcdate(),121)) FOR [dbaDateUpdated], CONSTRAINT [DF_Content_dbaIsActive] DEFAULT (1) FOR [dbaIsActive], CONSTRAINT [DF_Content_dbaIsDeleted] DEFAULT (0) FOR [dbaIsDeleted], CONSTRAINT [PK_Content] PRIMARY KEY NONCLUSTERED ( [ContentID] ) ON [PRIMARY] GO CREATE UNIQUE INDEX [IX_Content_RowID] ON [dbo].[Content]([RowID]) ON [PRIMARY] GO ALTER TABLE [dbo].[Version] ADD CONSTRAINT [DF_Version_RowID] DEFAULT (newid()) FOR [RowID], CONSTRAINT [DF_Version_dbaDateCreated] DEFAULT (convert(nchar(19),getutcdate(),121)) FOR [dbaDateCreated], CONSTRAINT [DF_Version_dbaDateUpdated] DEFAULT (convert(nchar(19),getutcdate(),121)) FOR [dbaDateUpdated], CONSTRAINT [DF_Version_dbaIsActive] DEFAULT (1) FOR [dbaIsActive], CONSTRAINT [DF_Version_dbaIsDeleted] DEFAULT (0) FOR [dbaIsDeleted], CONSTRAINT [PK_Version] PRIMARY KEY NONCLUSTERED ( [VersionID] ) ON [PRIMARY] GO CREATE UNIQUE INDEX [AK_Version_Text] ON [dbo].[Version]([VersionText]) ON [PRIMARY] GO CREATE UNIQUE INDEX [AK_Version_Version] ON [dbo].[Version]([VersionMajor], [VersionMinor]) ON [PRIMARY] GO CREATE UNIQUE INDEX [IX_Version_RowID] ON [dbo].[Version]([RowID]) ON [PRIMARY] GO ALTER TABLE [dbo].[EntityContent] ADD CONSTRAINT [DF_EntityContent_RowID] DEFAULT (newid()) FOR [RowID], CONSTRAINT [DF_EntityContent_dbaDateCreated] DEFAULT (convert(nchar(19),getutcdate(),121)) FOR [dbaDateCreated], CONSTRAINT [DF_EntityContent_dbaDateUpdated] DEFAULT (convert(nchar(19),getutcdate(),121)) FOR [dbaDateUpdated], CONSTRAINT [DF_EntityContent_dbaIsActive] DEFAULT (1) FOR [dbaIsActive], CONSTRAINT [DF_EntityContent_dbaIsDeleted] DEFAULT (0) FOR [dbaIsDeleted], CONSTRAINT [PK_EntityContent] PRIMARY KEY NONCLUSTERED ( [EntityContentID] ) ON [PRIMARY] GO CREATE UNIQUE INDEX [AK_EntityContent_Version] ON [dbo].[EntityContent]([EntityGUID], [VersionID]) ON [PRIMARY] GO CREATE UNIQUE INDEX [IX_EntityContent_RowID] ON [dbo].[EntityContent]([RowID]) ON [PRIMARY] GO ALTER TABLE [dbo].[EntityContent] ADD CONSTRAINT [FK_EntityContent_ContentID_Content_ContentID] FOREIGN KEY ( [ContentID] ) REFERENCES [dbo].[Content] ( [ContentID] ), CONSTRAINT [FK_EntityContent_VersionID_Version_VersionID] FOREIGN KEY ( [VersionID] ) REFERENCES [dbo].[Version] ( [VersionID] ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE TRIGGER trgDbaInsContent ON Content FOR INSERT AS Declare @ContentID int, @dbaDateCreated datetime, @dbaDateUpdated datetime, @dbaIsActive tinyint, @dbaIsDeleted tinyint Select @ContentID = ContentID, @dbaDateCreated = dbaDateCreated, @dbaDateUpdated = dbaDateUpdated, @dbaIsActive = dbaIsActive, @dbaIsDeleted = dbaIsDeleted From inserted If @dbaDateCreated = Null OR Not(Update(dbaDateCreated)) Set @dbaDateCreated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateCreated = (convert(nchar(19),@dbaDateCreated,121)) If @dbaDateUpdated = Null OR Not(Update(dbaDateUpdated)) Set @dbaDateUpdated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateUpdated = (convert(nchar(19),@dbaDateUpdated,121)) If @dbaIsActive = Null Set @dbaIsActive = 1 If @dbaIsDeleted = Null Set @dbaIsDeleted = 0 Update Content Set dbaDateCreated = @dbaDateCreated, dbaDateUpdated = @dbaDateUpdated, dbaIsActive = @dbaIsActive, dbaIsDeleted = @dbaIsDeleted Where ContentID = @ContentID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE TRIGGER trgDbaUpdContent ON Content FOR UPDATE AS Declare @ContentID int, @dbaDateCreated datetime, @dbaDateUpdated datetime, @dbaIsActive tinyint, @dbaIsDeleted tinyint Select @ContentID = ContentID, @dbaDateCreated = dbaDateCreated, @dbaDateUpdated = dbaDateUpdated, @dbaIsActive = dbaIsActive, @dbaIsDeleted = dbaIsDeleted From inserted If @dbaDateCreated = Null Set @dbaDateCreated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateCreated = (convert(nchar(19),@dbaDateCreated,121)) If @dbaDateUpdated = Null OR Not(Update(dbaDateUpdated)) Set @dbaDateUpdated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateUpdated = (convert(nchar(19),@dbaDateUpdated,121)) If @dbaIsActive = Null Set @dbaIsActive = 1 If @dbaIsDeleted = Null Set @dbaIsDeleted = 0 Update Content Set dbaDateCreated = @dbaDateCreated, dbaDateUpdated = @dbaDateUpdated, dbaIsActive = @dbaIsActive, dbaIsDeleted = @dbaIsDeleted Where ContentID = @ContentID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE TRIGGER trgDbaDelContent ON Content INSTEAD OF DELETE AS Declare @ContentID int, @dbaDateCreated datetime, @dbaDateUpdated datetime, @dbaIsActive tinyint, @dbaIsDeleted tinyint Select @ContentID = ContentID, @dbaDateCreated = dbaDateCreated, @dbaDateUpdated = dbaDateUpdated, @dbaIsActive = dbaIsActive, @dbaIsDeleted = dbaIsDeleted From deleted If @dbaDateCreated = Null Set @dbaDateCreated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateCreated = (convert(nchar(19),@dbaDateCreated,121)) If @dbaDateUpdated = Null OR Not(Update(dbaDateUpdated)) Set @dbaDateUpdated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateUpdated = (convert(nchar(19),@dbaDateUpdated,121)) If @dbaIsActive = Null OR @dbaIsActive = 1 OR Not(Update(dbaIsActive)) Set @dbaIsActive = 0 If @dbaIsDeleted = Null OR @dbaIsDeleted = 0 OR Not(Update(dbaIsDeleted)) Set @dbaIsDeleted = 1 Update Content Set dbaDateCreated = @dbaDateCreated, dbaDateUpdated = @dbaDateUpdated, dbaIsActive = @dbaIsActive, dbaIsDeleted = @dbaIsDeleted Where ContentID = @ContentID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE TRIGGER trgDbaInsVersion ON Version FOR INSERT AS Declare @VersionID int, @dbaDateCreated datetime, @dbaDateUpdated datetime, @dbaIsActive tinyint, @dbaIsDeleted tinyint Select @VersionID = VersionID, @dbaDateCreated = dbaDateCreated, @dbaDateUpdated = dbaDateUpdated, @dbaIsActive = dbaIsActive, @dbaIsDeleted = dbaIsDeleted From inserted If @dbaDateCreated = Null OR Not(Update(dbaDateCreated)) Set @dbaDateCreated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateCreated = (convert(nchar(19),@dbaDateCreated,121)) If @dbaDateUpdated = Null OR Not(Update(dbaDateUpdated)) Set @dbaDateUpdated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateUpdated = (convert(nchar(19),@dbaDateUpdated,121)) If @dbaIsActive = Null Set @dbaIsActive = 1 If @dbaIsDeleted = Null Set @dbaIsDeleted = 0 Update Version Set dbaDateCreated = @dbaDateCreated, dbaDateUpdated = @dbaDateUpdated, dbaIsActive = @dbaIsActive, dbaIsDeleted = @dbaIsDeleted Where VersionID = @VersionID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE TRIGGER trgDbaUpdVersion ON Version FOR UPDATE AS Declare @VersionID int, @dbaDateCreated datetime, @dbaDateUpdated datetime, @dbaIsActive tinyint, @dbaIsDeleted tinyint Select @VersionID = VersionID, @dbaDateCreated = dbaDateCreated, @dbaDateUpdated = dbaDateUpdated, @dbaIsActive = dbaIsActive, @dbaIsDeleted = dbaIsDeleted From inserted If @dbaDateCreated = Null Set @dbaDateCreated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateCreated = (convert(nchar(19),@dbaDateCreated,121)) If @dbaDateUpdated = Null OR Not(Update(dbaDateUpdated)) Set @dbaDateUpdated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateUpdated = (convert(nchar(19),@dbaDateUpdated,121)) If @dbaIsActive = Null Set @dbaIsActive = 1 If @dbaIsDeleted = Null Set @dbaIsDeleted = 0 Update Version Set dbaDateCreated = @dbaDateCreated, dbaDateUpdated = @dbaDateUpdated, dbaIsActive = @dbaIsActive, dbaIsDeleted = @dbaIsDeleted Where VersionID = @VersionID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE TRIGGER trgDbaDelVersion ON Version INSTEAD OF DELETE AS Declare @VersionID int, @dbaDateCreated datetime, @dbaDateUpdated datetime, @dbaIsActive tinyint, @dbaIsDeleted tinyint Select @VersionID = VersionID, @dbaDateCreated = dbaDateCreated, @dbaDateUpdated = dbaDateUpdated, @dbaIsActive = dbaIsActive, @dbaIsDeleted = dbaIsDeleted From deleted If @dbaDateCreated = Null Set @dbaDateCreated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateCreated = (convert(nchar(19),@dbaDateCreated,121)) If @dbaDateUpdated = Null OR Not(Update(dbaDateUpdated)) Set @dbaDateUpdated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateUpdated = (convert(nchar(19),@dbaDateUpdated,121)) If @dbaIsActive = Null OR @dbaIsActive = 1 OR Not(Update(dbaIsActive)) Set @dbaIsActive = 0 If @dbaIsDeleted = Null OR @dbaIsDeleted = 0 OR Not(Update(dbaIsDeleted)) Set @dbaIsDeleted = 1 Update Version Set dbaDateCreated = @dbaDateCreated, dbaDateUpdated = @dbaDateUpdated, dbaIsActive = @dbaIsActive, dbaIsDeleted = @dbaIsDeleted Where VersionID = @VersionID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE TRIGGER trgDbaInsEntityContent ON EntityContent FOR INSERT AS Declare @EntityContentID int, @dbaDateCreated datetime, @dbaDateUpdated datetime, @dbaIsActive tinyint, @dbaIsDeleted tinyint Select @EntityContentID = EntityContentID, @dbaDateCreated = dbaDateCreated, @dbaDateUpdated = dbaDateUpdated, @dbaIsActive = dbaIsActive, @dbaIsDeleted = dbaIsDeleted From inserted If @dbaDateCreated = Null OR Not(Update(dbaDateCreated)) Set @dbaDateCreated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateCreated = (convert(nchar(19),@dbaDateCreated,121)) If @dbaDateUpdated = Null OR Not(Update(dbaDateUpdated)) Set @dbaDateUpdated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateUpdated = (convert(nchar(19),@dbaDateUpdated,121)) If @dbaIsActive = Null Set @dbaIsActive = 1 If @dbaIsDeleted = Null Set @dbaIsDeleted = 0 Update EntityContent Set dbaDateCreated = @dbaDateCreated, dbaDateUpdated = @dbaDateUpdated, dbaIsActive = @dbaIsActive, dbaIsDeleted = @dbaIsDeleted Where EntityContentID = @EntityContentID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE TRIGGER trgDbaUpdEntityContent ON EntityContent FOR UPDATE AS Declare @EntityContentID int, @dbaDateCreated datetime, @dbaDateUpdated datetime, @dbaIsActive tinyint, @dbaIsDeleted tinyint Select @EntityContentID = EntityContentID, @dbaDateCreated = dbaDateCreated, @dbaDateUpdated = dbaDateUpdated, @dbaIsActive = dbaIsActive, @dbaIsDeleted = dbaIsDeleted From inserted If @dbaDateCreated = Null Set @dbaDateCreated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateCreated = (convert(nchar(19),@dbaDateCreated,121)) If @dbaDateUpdated = Null OR Not(Update(dbaDateUpdated)) Set @dbaDateUpdated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateUpdated = (convert(nchar(19),@dbaDateUpdated,121)) If @dbaIsActive = Null Set @dbaIsActive = 1 If @dbaIsDeleted = Null Set @dbaIsDeleted = 0 Update EntityContent Set dbaDateCreated = @dbaDateCreated, dbaDateUpdated = @dbaDateUpdated, dbaIsActive = @dbaIsActive, dbaIsDeleted = @dbaIsDeleted Where EntityContentID = @EntityContentID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE TRIGGER trgDbaDelEntityContent ON EntityContent INSTEAD OF DELETE AS Declare @EntityContentID int, @dbaDateCreated datetime, @dbaDateUpdated datetime, @dbaIsActive tinyint, @dbaIsDeleted tinyint Select @EntityContentID = EntityContentID, @dbaDateCreated = dbaDateCreated, @dbaDateUpdated = dbaDateUpdated, @dbaIsActive = dbaIsActive, @dbaIsDeleted = dbaIsDeleted From deleted If @dbaDateCreated = Null Set @dbaDateCreated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateCreated = (convert(nchar(19),@dbaDateCreated,121)) If @dbaDateUpdated = Null OR Not(Update(dbaDateUpdated)) Set @dbaDateUpdated = (convert(nchar(19),getutcdate(),121)) Else Set @dbaDateUpdated = (convert(nchar(19),@dbaDateUpdated,121)) If @dbaIsActive = Null OR @dbaIsActive = 1 OR Not(Update(dbaIsActive)) Set @dbaIsActive = 0 If @dbaIsDeleted = Null OR @dbaIsDeleted = 0 OR Not(Update(dbaIsDeleted)) Set @dbaIsDeleted = 1 Update EntityContent Set dbaDateCreated = @dbaDateCreated, dbaDateUpdated = @dbaDateUpdated, dbaIsActive = @dbaIsActive, dbaIsDeleted = @dbaIsDeleted Where EntityContentID = @EntityContentID GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. nText and Text column comparision improvements required
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_EntityContent_ContentID_Content_ContentID]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[EntityContent] ...
0 votes
nText and Text column comparision improvements required
  1. Community
  2. SQL Data Compare Previous Versions
When comparing Text or nText columns I receive the report that records are different. If I investigate each record using the data compare 5 UI, each one is equal. The correct results would be tha...
2 followers 3 comments 0 votes
So the approach here is to use the Where clause to limit the ROWCOUNT, causing the user to manually change the where clause X number of times to compare and synchronize the entire recordset. This seems to be a conflict in automation. The approach should be to specify a SET ROWCOUNT = Y, (i.e. 10000), value. Red-Gate data compare would then generate multiple insert, update or delete scripts. Likewise the schemacompare would populate a rebuilt table like this, with no begin/committ transactions and assuming a backup is available and disk space optimization is preferred: SET ROWCOUNT 10000 While 0 = 0 Begin -- populate rebuilt table INSERT INTO [dbo].[tmpxxx_table] ([tableID], [field1], [dbaDateCreated], [dbaDateUpdated], [dbaIsActive], [dbaIsDeleted]) SELECT [tableID], [field1], [dbaDateCreated], [dbaDateUpdated], [dbaIsActive], [dbaIsDeleted] from [dbo]. @ROWCOUNT = 0) BREAK End GO / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. insufficient system memory error during synchronisation
So the approach here is to use the Where clause to limit the ROWCOUNT, causing the user to manually change the where clause X number of times to compare and synchronize the entire recordset. This s...
0 votes
Select @ServerName +'/' + DB_Name() as varchar(35)) as ServerDBName, sp.type, Cast(sp.name As varchar(20)) As XP_Name, Cast(sp.[value] As varchar(45)) As XP_Value, Cast(so.name as varchar(25)) As TableName From sysproperties sp INNER JOIN sysobjects so ON sp.id = so.id Where sp.name = 'OrderByStatement' ServerDBName type XP_Name XP_Value TableName ---- T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc PatientPractitioner T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc Attribute T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by entrydate desc POCJournalEntry T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc POCPractitioner T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by weekday asc,starttimeoffset asc EmployeeAvailability T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc ReferralContact T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc EncounterService T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc Selection T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc EntityAddress T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc EntityEMail T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc EntityLocation T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc EntityNarrative T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc EntityTelephone T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc PatientContactRole T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc PatientInsurance T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc AdmissionEmployee T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc AdmissionHealthPlan T001827-WXP5/OFFICE01_POCOFFICE 3 OrderByStatement order by rank asc PatientPharmacy (18 row(s) affected) / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Incorrectly reporting missing Extended Property
Select@ServerName +'/' + DB_Name() as varchar(35)) as ServerDBName, sp.type, Cast(sp.name As varchar(20)) As XP_Name, Cast(sp.[value] As varchar(45)) As XP_Value, Cast(so.name as varchar(25)) As Ta...
0 votes
Total activity
29
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
8