Incorrect DBCC CHECKIDENT script

paulo_morgadopaulo_morgado Portugal Posts: 96 Silver 2
edited June 9, 2010 7:30PM in SQL Compare Previous Versions
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)
Paulo Morgado
Portugal
Web Site
Weblog
Twitter

Comments

Sign In or Register to comment.