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

Activity overview

Latest activity by ktrock

Maybe an option setting somewhere in SSMS but nothing stands out at me. Ken / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare 9 generates unnecessary PK drop/add
Maybe an option setting somewhere in SSMS but nothing stands out at me. Ken
0 votes
It's 10.0.2531.0, which comes with or is part of SQL 2008 SP1. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare 9 generates unnecessary PK drop/add
It's 10.0.2531.0, which comes with or is part of SQL 2008 SP1.
0 votes
While I'm here let me ask you, why does launching SQL Compare from within SSMS ask to save the contents of unsaved windows? It's not like starting Compare shuts down SSMS. Ken / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare 9 generates unnecessary PK drop/add
While I'm here let me ask you, why does launching SQL Compare from within SSMS ask to save the contents of unsaved windows? It's not like starting Compare shuts down SSMS. Ken
0 votes
Yes, SQL Compare is behaving exactly as it should. Thanks, Ken / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare 9 generates unnecessary PK drop/add
Yes, SQL Compare is behaving exactly as it should. Thanks, Ken
0 votes
USE [dbACSS] GO /****** Object: Table [Summary].[tblScreenUsageByTypeID] Script Date: 12/19/2011 11:56:53 ******/ --This is the source SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [Summary].[tblScreenUsageByTypeID]( [ScreenUsageTypeID] [smallint] NOT NULL, [UsageDate] [smalldatetime] NOT NULL, [EmployeeID] [varchar](20) NOT NULL, [TotalClicks] [int] NULL, [UniqueClicks] [int] NULL, CONSTRAINT [PK_tblScreenUsageByTypeID] PRIMARY KEY CLUSTERED ( [ScreenUsageTypeID] ASC, [UsageDate] ASC, [EmployeeID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY] ) ON [SECONDARY] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Total screen clicks by ACSS Call Id per day' , @level0type=N'SCHEMA',@level0name=N'Summary', @level1type=N'TABLE',@level1name=N'tblScreenUsageByTypeID', @level2type=N'COLUMN',@level2name=N'TotalClicks' GO USE [dbACSS] GO /****** Object: Table [Summary].[tblScreenUsageByTypeID] Script Date: 12/19/2011 11:55:49 ******/ --This is the destination SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [Summary].[tblScreenUsageByTypeID]( [ScreenUsageTypeID] [smallint] NOT NULL, [UsageDate] [smalldatetime] NOT NULL, [EmployeeID] [varchar](20) NOT NULL, [TotalClicks] [int] NULL, [UniqueClicks] [int] NULL, CONSTRAINT [PK_tblScreenUsageByTypeID] PRIMARY KEY NONCLUSTERED ( [ScreenUsageTypeID] ASC, [UsageDate] ASC, [EmployeeID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [INDEXES] ) ON [SECONDARY] GO SET ANSI_PADDING OFF GO USE [dbACSS] /****** Object: Index [ixUsageDate] Script Date: 12/19/2011 11:55:49 ******/ CREATE CLUSTERED INDEX [ixUsageDate] ON [Summary].[tblScreenUsageByTypeID] ( [UsageDate] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SECONDARY] GO I see it! The PK is on different filegroups in the source and destination. Funny that the upgrade script wants to put it back on the default filegroup. Ken / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare 9 generates unnecessary PK drop/add
USE [dbACSS] GO /****** Object: Table [Summary].[tblScreenUsageByTypeID] Script Date: 12/19/2011 11:56:53 ******/ --This is the source SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_...
0 votes
SQL Compare 9 generates unnecessary PK drop/add
  1. Community
  2. SQL Compare Previous Versions
Hello. SQL Compare 9 generated a syncronization script for me on a single SP and syncronizing dependencies. A referenced table in the source had only a PK. The destination had the exact same PK and...
2 followers 9 comments 0 votes
Total activity
7
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1