How can we help you today? How can we help you today?
Mickeman
Activity overview Badges (0) Posts (1) Comments (4)

Comments

Sort by recent activity
1) Sorry, I'm not allowed to send away a snapshot of the db. 2) 6.2.0.271 3) Behavior: Nothing checked. Ignore: Everything checked except: Comments WITH NOCHECK Extended proterties SET QUOTED_IDENTIFIER... The LOCK properties... Identity property on columns. 4) SQL server 2000 Standard Edition, sp4 and SQL server 2000 Enterprise Edition, sp4 / comments
  1. Community
  2. SQL Compare Previous Versions
  3. DROP CONSTRAINT
1) Sorry, I'm not allowed to send away a snapshot of the db. 2) 6.2.0.271 3) Behavior: Nothing checked. Ignore: Everything checked except: Comments WITH NOCHECK Extended proterties SET QUOTED_IDENT...
0 votes
Yes, but only when choose either Views, Stored Procs or Functions. I also did "EXEC sp_helpconstraint TblBokOrder" against the TblBokOrder in the receiving DB (the one that gonna be updated). There are only a PK, BOid and a FK : FK_TblBORader_TblBokOrderTblBORader / comments
  1. Community
  2. SQL Compare Previous Versions
  3. DROP CONSTRAINT
Yes, but only when choose either Views, Stored Procs or Functions. I also did "EXEC sp_helpconstraint TblBokOrder" against the TblBokOrder in the receiving DB (the one that gonna be updated). There...
0 votes
The column I want to update "BOStatus " is not a part of the Primay Key. I don't really understand why I should need to drop constraint in this case. I did create script of both tables to show you PK and indexes and so on. if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TblBORader_TblBokOrder]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TblBORader] DROP CONSTRAINT FK_TblBORader_TblBokOrder GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TblBokOrder]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TblBokOrder] GO CREATE TABLE [dbo].[TblBokOrder] ( [BOId] [bigint] IDENTITY (1, 1) NOT NULL , [BOTyp] [char] (10) COLLATE Finnish_Swedish_CI_AS NULL , [BOText] [varchar] (50) COLLATE Finnish_Swedish_CI_AS NULL , [BOStatus] [char] (10) COLLATE Finnish_Swedish_CI_AS NULL , [BODatum] [varchar] (20) COLLATE Finnish_Swedish_CI_AS NULL , [BOChangedDate] [varchar] (20) COLLATE Finnish_Swedish_CI_AS NULL , [BOChangedBy] [bigint] NULL , [BOCreatedBy] [bigint] NULL , [BOFelText] [varchar] (255) COLLATE Finnish_Swedish_CI_AS NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[TblBokOrder] ADD CONSTRAINT [PK_TblBokOrder] PRIMARY KEY NONCLUSTERED ( [BOId] ) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [IDX1_TblBokOrder] ON [dbo].[TblBokOrder]([BOTyp], [BOStatus], [BODatum], [BOChangedBy], [BOCreatedBy]) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [IX_TblBokOrder] ON [dbo].[TblBokOrder]([BOId], [BOTyp]) WITH FILLFACTOR = 90 ON [PRIMARY] GO and on TblBORader: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TblLoggBO_TblBORader]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TblLoggBO] DROP CONSTRAINT FK_TblLoggBO_TblBORader GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TblBORader]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TblBORader] GO CREATE TABLE [dbo].[TblBORader] ( [BORadId] [bigint] IDENTITY (1, 1) NOT NULL , [BOId] [bigint] NULL , [BORadnr] [bigint] NULL , [VerRadId] [bigint] NULL , [UppdragId] [bigint] NULL , [Produkt] [int] NULL , [Projekt] [int] NULL , [Anlaggning] [int] NULL , [Konto] [int] NULL , [BORadBeloppKredit] [bigint] NULL , [BORadBeloppDebit] [bigint] NULL , [BORadPeriodBokF] [char] (10) COLLATE Finnish_Swedish_CI_AS NULL , [BORadDatumBokF] [varchar] (20) COLLATE Finnish_Swedish_CI_AS NULL , [BORadTranstext] [varchar] (50) COLLATE Finnish_Swedish_CI_AS NULL , [BORadStatus] [varchar] (10) COLLATE Finnish_Swedish_CI_AS NULL , [BORadChangedDate] [varchar] (20) COLLATE Finnish_Swedish_CI_AS NULL , [BORadChangedBy] [bigint] NULL , [BORadForAttestDate] [varchar] (20) COLLATE Finnish_Swedish_CI_AS NULL , [BORadForAttestBy] [bigint] NULL , [BORadAttestDate] [varchar] (20) COLLATE Finnish_Swedish_CI_AS NULL , [BORadAttestBy] [bigint] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[TblBORader] ADD CONSTRAINT [PK_TblBORader] PRIMARY KEY NONCLUSTERED ( [BORadId] ) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [IDX1_TblBORader] ON [dbo].[TblBORader]([BOId], [VerRadId], [UppdragId], [Konto], [BORadPeriodBokF], [BORadStatus], [BORadChangedBy], [BORadAttestBy], [BORadAttestDate], [BORadForAttestDate]) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE INDEX [IX_TblBORader] ON [dbo].[TblBORader]([BORadPeriodBokF]) WITH FILLFACTOR = 90 ON [PRIMARY] GO ALTER TABLE [dbo].[TblBORader] ADD CONSTRAINT [FK_TblBORader_TblBokOrder] FOREIGN KEY ( [BOId] ) REFERENCES [dbo].[TblBokOrder] ( [BOId] ), CONSTRAINT [FK_TblBORader_tblUppdrag] FOREIGN KEY ( [UppdragId] ) REFERENCES [dbo].[tblUppdrag] ( [UppdragId] ) GO / comments
  1. Community
  2. SQL Compare Previous Versions
  3. DROP CONSTRAINT
The column I want to update "BOStatus " is not a part of the Primay Key. I don't really understand why I should need to drop constraint in this case. I did create script of both tables to show you ...
0 votes
Exactly, char 10 to varchar 10. Now I did the change directly in Enterprise Mangager without any problem and here is the script what SQL Server did: BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON COMMIT BEGIN TRANSACTION CREATE TABLE dbo.Tmp_TblBokOrder ( BOId bigint NOT NULL IDENTITY (1, 1), BOTyp char(10) NULL, BOText varchar(50) NULL, BOStatus varchar(10) NULL, BODatum varchar(20) NULL, BOChangedDate varchar(20) NULL, BOChangedBy bigint NULL, BOCreatedBy bigint NULL, BOFelText varchar(255) NULL ) ON [PRIMARY] GO SET IDENTITY_INSERT dbo.Tmp_TblBokOrder ON GO IF EXISTS(SELECT * FROM dbo.TblBokOrder) EXEC('INSERT INTO dbo.Tmp_TblBokOrder (BOId, BOTyp, BOText, BOStatus, BODatum, BOChangedDate, BOChangedBy, BOCreatedBy, BOFelText) SELECT BOId, BOTyp, BOText, CONVERT(varchar(10), BOStatus), BODatum, BOChangedDate, BOChangedBy, BOCreatedBy, BOFelText FROM dbo.TblBokOrder (HOLDLOCK TABLOCKX)') GO SET IDENTITY_INSERT dbo.Tmp_TblBokOrder OFF GO ALTER TABLE dbo.TblBORader DROP CONSTRAINT FK_TblBORader_TblBokOrder GO DROP TABLE dbo.TblBokOrder GO EXECUTE sp_rename N'dbo.Tmp_TblBokOrder', N'TblBokOrder', 'OBJECT' GO ALTER TABLE dbo.TblBokOrder ADD CONSTRAINT PK_TblBokOrder PRIMARY KEY NONCLUSTERED ( BOId ) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE NONCLUSTERED INDEX IDX1_TblBokOrder ON dbo.TblBokOrder ( BOTyp, BOStatus, BODatum, BOChangedBy, BOCreatedBy ) WITH FILLFACTOR = 90 ON [PRIMARY] GO CREATE NONCLUSTERED INDEX IX_TblBokOrder ON dbo.TblBokOrder ( BOId, BOTyp ) WITH FILLFACTOR = 90 ON [PRIMARY] GO COMMIT BEGIN TRANSACTION ALTER TABLE dbo.TblBORader WITH NOCHECK ADD CONSTRAINT FK_TblBORader_TblBokOrder FOREIGN KEY ( BOId ) REFERENCES dbo.TblBokOrder ( BOId ) GO COMMIT / comments
  1. Community
  2. SQL Compare Previous Versions
  3. DROP CONSTRAINT
Exactly, char 10 to varchar 10. Now I did the change directly in Enterprise Mangager without any problem and here is the script what SQL Server did: BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET A...
0 votes
Total activity
6
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1