Incorrect DBCC CHECKIDENT script

SQL Compare 8.2.0.16

The script being generated is:

DECLARE @idVal INT
SELECT @idVal = IDENT_CURRENT&#40;N'Aplicacoes'&#41;
DBCC CHECKIDENT&#40;&#91;tmp_rg_xx_Aplicacoes&#93;, RESEED, @idVal&#41;

and it should be:

DECLARE @idVal INT
SELECT @idVal = IDENT_CURRENT&#40;N'Historico.Aplicacoes'&#41;
DBCC CHECKIDENT&#40;'&#91;Historico&#93;.&#91;tmp_rg_xx_Aplicacoes&#93;', RESEED, @idVal&#41;

paulo_morgado June 09, 2010 04:38

Comments

2 comments

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.

Brian Donahue June 09, 2010 09:54

0
The cumulative patch fixed it. Thanks.

paulo_morgado June 09, 2010 19:30

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Incorrect DBCC CHECKIDENT script

Comments

Add comment