The new sequence object in sql 2012 cannot be formatted

[gvarol@corelogic.com]

anywhere in the script file if the last line below is used it causes an error.

CREATE SEQUENCE [dbo].[ReportComparisonSeq] AS INT START WITH 1 INCREMENT BY 1 NO CYCLE CACHE 10
go
DECLARE @Seq INT
SELECT @Seq = NEXT VALUE FOR [dbo].[ReportComparisonSeq]

[Manfred.Castro]

Unfortunately although the majority of our products support connections to SQL 2012. We do not as of yet support all the new features of SQL 2012.
You can request a feature to include 2012 syntax at out uservoice forums.
http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions
_________________
Manfred Castro
Product Support
Red Gate Software