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

Comments

Sort by recent activity
Okay--the problem came back and affected the very same tables. I ran a comparison using SQL Compare v10 and the differences appear there as well. Full scripts below. I should also note that I've been using SQL Data Compare v9 to occasionally refresh the data in the development database with production data. Maybe it's doing something to the constraints? Database -- Columns CREATE TABLE [dbo].[tblAnnualPerformanceHistory] ( [AnnualPerformanceHistoryID] [int] NOT NULL IDENTITY(1, 1) NOT FOR REPLICATION, [FundID] [int] NOT NULL CONSTRAINT [DF__Temporary__FundI__7720AD13] DEFAULT (0), [PerfYear] [smallint] NOT NULL, [Performance] [float] NULL, [EstimateFlag] [bit] NOT NULL CONSTRAINT [DF_tblAnnualPerformanceHistory_EstimateFlag] DEFAULT (0), [GrossFlag] [bit] NOT NULL CONSTRAINT [DF_tblAnnualPerformanceHistory_GrossFlag] DEFAULT (0), [CheckedFlag] [bit] NOT NULL CONSTRAINT [DF_tblAnnualPerformanceHistory_CheckedFlag] DEFAULT (0), [PerformanceSourceID] [int] NOT NULL CONSTRAINT [DF_tblAnnualPerformanceHistory_SourceID] DEFAULT ((1)), [DateEntered] [smalldatetime] NULL CONSTRAINT [DF_tblAnnualPerformanceHistory_DateEntered] DEFAULT (getdate()) ) ON [PRIMARY] GO -- Triggers CREATE TRIGGER [dbo].[tblAnnualPerformanceHist_ITrig] ON [dbo].[tblAnnualPerformanceHistory] FOR INSERT AS SET NOCOUNT ON /* * VALIDATION RULE FOR FIELD 'PerfYear' */ IF (SELECT Count(*) FROM inserted WHERE NOT (PerfYear>1900 And PerfYear<2999)) > 0 BEGIN RAISERROR 44444 'You must enter a year betwen 1900 and 2999!' ROLLBACK TRANSACTION END GO CREATE TRIGGER [dbo].[tblAnnualPerformanceHist_UTrig] ON [dbo].[tblAnnualPerformanceHistory] FOR UPDATE AS SET NOCOUNT ON /* * VALIDATION RULE FOR FIELD 'PerfYear' */ IF (SELECT Count(*) FROM inserted WHERE NOT (PerfYear>1900 And PerfYear<2999)) > 0 BEGIN RAISERROR 44444 'You must enter a year betwen 1900 and 2999!' ROLLBACK TRANSACTION END GO -- Constraints and Indexes ALTER TABLE [dbo].[tblAnnualPerformanceHistory] WITH NOCHECK ADD CONSTRAINT [CK_tblAnnualPerformanceHistory] CHECK (([PerfYear] >= 1900 and [PerfYear] <= 2200)) GO ALTER TABLE [dbo].[tblAnnualPerformanceHistory] ADD CONSTRAINT [aaaaatblAnnualPerformanceHistory_PK] PRIMARY KEY NONCLUSTERED ([AnnualPerformanceHistoryID]) WITH (FILLFACTOR=90) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [ID] ON [dbo].[tblAnnualPerformanceHistory] ([AnnualPerformanceHistoryID]) WITH (FILLFACTOR=90) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [FundID] ON [dbo].[tblAnnualPerformanceHistory] ([FundID]) WITH (FILLFACTOR=90) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [MasterFieldsListtblAnnualPerformanceHistory] ON [dbo].[tblAnnualPerformanceHistory] ([FundID]) WITH (FILLFACTOR=90) ON [PRIMARY] GO -- Foreign Keys ALTER TABLE [dbo].[tblAnnualPerformanceHistory] ADD CONSTRAINT [tblAnnualPerformanceHisto_FK00] FOREIGN KEY ([FundID]) REFERENCES [dbo].[tblHedgeFunds] ([FundID]) GO -- Extended Properties DECLARE @xp tinyint SELECT @xp=2 EXEC sp_addextendedproperty N'MS_DefaultView', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO EXEC sp_addextendedproperty N'MS_Filter', NULL, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO EXEC sp_addextendedproperty N'MS_OrderBy', NULL, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_OrderByOn', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO DECLARE @xp tinyint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_Orientation', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO DECLARE @xp int SELECT @xp=10000 EXEC sp_addextendedproperty N'MS_TableMaxRecords', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'AnnualPerformanceHistoryID' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'AnnualPerformanceHistoryID' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'AnnualPerformanceHistoryID' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO EXEC sp_addextendedproperty N'MS_DisplayControl', N'109', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO EXEC sp_addextendedproperty N'MS_Format', N'', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO EXEC sp_addextendedproperty N'MS_IMEMode', N'0', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO EXEC sp_addextendedproperty N'MS_DisplayControl', N'109', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO EXEC sp_addextendedproperty N'MS_Format', N'', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO EXEC sp_addextendedproperty N'MS_IMEMode', N'0', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'FundID' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'FundID' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'FundID' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO EXEC sp_addextendedproperty N'MS_DisplayControl', N'109', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO EXEC sp_addextendedproperty N'MS_Format', N'', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO EXEC sp_addextendedproperty N'MS_IMEMode', N'0', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'Performance' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'Performance' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'Performance' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'PerfYear' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'PerfYear' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'PerfYear' GO Source Control -- Columns CREATE TABLE [dbo].[tblAnnualPerformanceHistory] ( [AnnualPerformanceHistoryID] [int] NOT NULL IDENTITY(1, 1) NOT FOR REPLICATION, [FundID] [int] NOT NULL CONSTRAINT [DF__Temporary__FundI__7720AD13] DEFAULT ((0)), [PerfYear] [smallint] NOT NULL, [Performance] [float] NULL, [EstimateFlag] [bit] NOT NULL CONSTRAINT [DF_tblAnnualPerformanceHistory_EstimateFlag] DEFAULT ((0)), [GrossFlag] [bit] NOT NULL CONSTRAINT [DF_tblAnnualPerformanceHistory_GrossFlag] DEFAULT ((0)), [CheckedFlag] [bit] NOT NULL CONSTRAINT [DF_tblAnnualPerformanceHistory_CheckedFlag] DEFAULT ((0)), [PerformanceSourceID] [int] NOT NULL CONSTRAINT [DF_tblAnnualPerformanceHistory_SourceID] DEFAULT ((1)), [DateEntered] [smalldatetime] NULL CONSTRAINT [DF_tblAnnualPerformanceHistory_DateEntered] DEFAULT (getdate()) ) ON [PRIMARY] GO -- Triggers CREATE TRIGGER [dbo].[tblAnnualPerformanceHist_ITrig] ON [dbo].[tblAnnualPerformanceHistory] FOR INSERT AS SET NOCOUNT ON /* * VALIDATION RULE FOR FIELD 'PerfYear' */ IF (SELECT Count(*) FROM inserted WHERE NOT (PerfYear>1900 And PerfYear<2999)) > 0 BEGIN RAISERROR 44444 'You must enter a year betwen 1900 and 2999!' ROLLBACK TRANSACTION END GO CREATE TRIGGER [dbo].[tblAnnualPerformanceHist_UTrig] ON [dbo].[tblAnnualPerformanceHistory] FOR UPDATE AS SET NOCOUNT ON /* * VALIDATION RULE FOR FIELD 'PerfYear' */ IF (SELECT Count(*) FROM inserted WHERE NOT (PerfYear>1900 And PerfYear<2999)) > 0 BEGIN RAISERROR 44444 'You must enter a year betwen 1900 and 2999!' ROLLBACK TRANSACTION END GO -- Constraints and Indexes ALTER TABLE [dbo].[tblAnnualPerformanceHistory] WITH NOCHECK ADD CONSTRAINT [CK_tblAnnualPerformanceHistory] CHECK (([PerfYear]>=(1900) AND [PerfYear]<=(2200))) GO ALTER TABLE [dbo].[tblAnnualPerformanceHistory] ADD CONSTRAINT [aaaaatblAnnualPerformanceHistory_PK] PRIMARY KEY NONCLUSTERED ([AnnualPerformanceHistoryID]) WITH (FILLFACTOR=90) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [ID] ON [dbo].[tblAnnualPerformanceHistory] ([AnnualPerformanceHistoryID]) WITH (FILLFACTOR=90) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [FundID] ON [dbo].[tblAnnualPerformanceHistory] ([FundID]) WITH (FILLFACTOR=90) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [MasterFieldsListtblAnnualPerformanceHistory] ON [dbo].[tblAnnualPerformanceHistory] ([FundID]) WITH (FILLFACTOR=90) ON [PRIMARY] GO -- Foreign Keys ALTER TABLE [dbo].[tblAnnualPerformanceHistory] WITH NOCHECK ADD CONSTRAINT [tblAnnualPerformanceHisto_FK00] FOREIGN KEY ([FundID]) REFERENCES [dbo].[tblHedgeFunds] ([FundID]) GO -- Extended Properties DECLARE @xp tinyint SELECT @xp=2 EXEC sp_addextendedproperty N'MS_DefaultView', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO EXEC sp_addextendedproperty N'MS_Filter', NULL, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO EXEC sp_addextendedproperty N'MS_OrderBy', NULL, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_OrderByOn', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO DECLARE @xp tinyint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_Orientation', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO DECLARE @xp int SELECT @xp=10000 EXEC sp_addextendedproperty N'MS_TableMaxRecords', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', NULL, NULL GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'AnnualPerformanceHistoryID' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'AnnualPerformanceHistoryID' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'AnnualPerformanceHistoryID' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO EXEC sp_addextendedproperty N'MS_DisplayControl', N'109', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO EXEC sp_addextendedproperty N'MS_Format', N'', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO EXEC sp_addextendedproperty N'MS_IMEMode', N'0', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'CheckedFlag' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO EXEC sp_addextendedproperty N'MS_DisplayControl', N'109', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO EXEC sp_addextendedproperty N'MS_Format', N'', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO EXEC sp_addextendedproperty N'MS_IMEMode', N'0', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'EstimateFlag' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'FundID' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'FundID' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'FundID' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO EXEC sp_addextendedproperty N'MS_DisplayControl', N'109', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO EXEC sp_addextendedproperty N'MS_Format', N'', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO EXEC sp_addextendedproperty N'MS_IMEMode', N'0', 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'GrossFlag' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'Performance' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'Performance' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'Performance' GO DECLARE @xp bit SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnHidden', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'PerfYear' GO DECLARE @xp smallint SELECT @xp=0 EXEC sp_addextendedproperty N'MS_ColumnOrder', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'PerfYear' GO DECLARE @xp smallint SELECT @xp=-1 EXEC sp_addextendedproperty N'MS_ColumnWidth', @xp, 'SCHEMA', N'dbo', 'TABLE', N'tblAnnualPerformanceHistory', 'COLUMN', N'PerfYear' GO / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Extra parentheses around table default values
Okay--the problem came back and affected the very same tables. I ran a comparison using SQL Compare v10 and the differences appear there as well. Full scripts below. I should also note that I've be...
0 votes
Unfortunately, I had already used "undo" on the differences shown in my original example. I'll post the full scripts when the issue crops up again (it's happened to us more than once, so I'm assuming it might happen again). / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Extra parentheses around table default values
Unfortunately, I had already used "undo" on the differences shown in my original example. I'll post the full scripts when the issue crops up again (it's happened to us more than once, so I'm assumi...
0 votes
Thanks for looking into this. 1. SQL Server Version: 2008 (v10.0.5500) 2. Compatibility Level: SQL Server 2008 (100) 3. Database version in XML file: 10 / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Extra parentheses around table default values
Thanks for looking into this. 1. SQL Server Version: 2008 (v10.0.5500) 2. Compatibility Level: SQL Server 2008 (100) 3. Database version in XML file: 10
0 votes
Thanks for the reply. You were correct -- I did mean to ask how to change a database's name in SQL Management Studio while retaining its source control history. Your process worked like a charm. Note that each user needs to re-link the database to the source control system after the name change. / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Renaming a source-controlled DB
Thanks for the reply. You were correct -- I did mean to ask how to change a database's name in SQL Management Studio while retaining its source control history. Your process worked like a charm. No...
0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2