Activity overview
Latest activity by cmorris73
Just in case others run into this error, I was able to find my issue and put a fix in. During the build process I was using to build a SQL Compare Diff script I was dynamically building a Version number inside a stored procedure. The dynamic SQL I was using to build this procedure did NOT have CR LF values for each line.
The fix was to add the following code at the end of each line in the dynamic SQL:
"+ char(13) + char(10) + "
or is you would like to see it in the dynamic SQL:
"
DECLARE @... varchar
set @... ='CREATE PROCEDURE sp_SetVersion' + char(13) + char(10) +
'As' + char(13) + char(10) +
'Begin' + char(13) + char(10) +
'SET NOCOUNT ON' + char(13) + char(10) +
' declare @version varchar(10), @build varchar(10), @date datetime' + char(13) + char(10) +
' set @version = ''' + @vVer + '''' + char(13) + char(10) +
' set @build = ''' + @vbuild + '''' + char(13) + char(10) +
' select @date = getdate()' + char(13) + char(10) +
' delete from [version]' + char(13) + char(10) +
' INSERT INTO [version](dbversion,[MinProductVersionsXml],[LastUpgradedDateTime])' + char(13) + char(10) +
'select @version + ''B'' + @build,CAST(''<MinProductVersions xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">' + char(13) + char(10) +
'<application application_name = "AppName1" requesting_application_identity="1">'' + @version + ''</application>' + char(13) + char(10) +
'</MinProductVersions>'' AS XML)' + char(13) + char(10) +
',GETDATE()' + char(13) + char(10) +
'END'
exec(@sql1)
"
The odd thing was this error was never reported in SQL versions prior to 2012 / comments
Just in case others run into this error, I was able to find my issue and put a fix in. During the build process I was using to build a SQL Compare Diff script I was dynamically building a Version ...
SQL 2012 warning: "inconsistent line endings"
I am using SQL Compare 10 to generate a DB Diff script to send out to clients for a database upgrade. In SQL 2012 I am receiving a warning when opening this Diff script saying "Inconsistent Line E...