Search
-
Re: Invalid syntax in CREATE TYPE statement
Comment by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsUnfortunately, I cannot reproduce this problem. When I use your script, SQL Compare recreates the type correctly:SET NUMERIC_ROUNDABORT OFFGOSET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ONGOIF EXISTS (SELECT * FROM tempdb..sysobjects WHERE… -
Invalid syntax in CREATE TYPE statement
My production logging server has received many ad-hoc changes over the past few months. I want to use SQL Compare to get the schema of the logging servers in testing in production in sync again to re-establish a meaningful testing process. SQL Compare is normally great for this task. But today it's generating invalid…
2 results