Incorrect DBCC CHECKIDENT script

paulo_morgado

SQL Compare 8.2.0.16

The script being generated is:

DECLARE @idVal INT
SELECT @idVal = IDENT_CURRENT(N'Aplicacoes')
DBCC CHECKIDENT([tmp_rg_xx_Aplicacoes], RESEED, @idVal)

and it should be:

DECLARE @idVal INT
SELECT @idVal = IDENT_CURRENT(N'Historico.Aplicacoes')
DBCC CHECKIDENT('[Historico].[tmp_rg_xx_Aplicacoes]', RESEED, @idVal)

Brian Donahue

Hello,

SQL Compare release version did not reseed tables when it was necessary to rebuild them. This was added as a feature in one of the cumulative updates, but was broken as you describe. It has now been fixed in the latest cumulative patch.

http://www.red-gate.com/messageboard/vi ... hp?t=11077

Feel free to let us know whether or not this fixes the problem.

paulo_morgado

The cumulative patch fixed it. Thanks.