User profile for ccollins – Support

Activity overview Badges (0) Posts (6) Comments (15)

Comments

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

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

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

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

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

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

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: February 06, 2025 13:27
Member since: February 04, 2025 15:14

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 8