Changed index not detected as a change

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Changed index not detected as a change

Postby rpresser » Thu Feb 03, 2011 12:01 am

I dropped and recreated two indexes on a table (I changed the filter expressions), but SQL Source Control does not offer to let me commit them.
rpresser
 
Posts: 7
Joined: Fri Jun 02, 2006 11:07 pm

Postby james.billings » Fri Feb 04, 2011 1:01 pm

Thanks for your post.

I've tried to replicate this myself with this kind of change:

Code: Select all
USE [AW2]
GO

/****** Object:  Index [IX_Test]    Script Date: 02/04/2011 11:48:05 ******/
IF  EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Test]') AND name = N'IX_Test')
DROP INDEX [IX_Test] ON [dbo].[Test] WITH ( ONLINE = OFF )
GO

USE [AW2]
GO

/****** Object:  Index [IX_Test]    Script Date: 02/04/2011 11:48:05 ******/
CREATE NONCLUSTERED INDEX [IX_Test] ON [dbo].[Test]
(
   [TID] ASC
)
WHERE [TID] < 0
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 [PRIMARY]
GO


Source Control correctly detected this (previously it was set to > 0 instead of < 0)

The difference is I am using the EAP of version 2.0 - so you may wish to test this out and see if it makes any difference? You'll find details here: http://www.red-gate.com/MessageBoard/viewtopic.php?t=12298.
The official version 2 is currently due out at the beginning of March (although this is subject to change of course)
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests