Comments
1 comment
-
rdobrich wrote:Hi,
I just run into very strange problem.
I have two stored that have two empty lines at the end on destination server. I have only one empty line on production server.
In sync script I don't have empty row, but in newly created stored I have one row.
That ever I try I get one extra line on destination server. (but just for that two stored).
Of cousse, when I check ignore white space, the stored are the same in SQL compare (but the one on destination have one empty line).
Can't reproduce error on other stored procedures, only on some.
Is I can see the sql compare script are fine (have exactly empty rows),
but SQL server 2005 Apply one more (on some very long ~600 lines) stores.
I think this is SQL server problem, but just point here at the problem .
(end of sync script loos fine, after applying script have one extra line)
...
return 0
error_spG_IzlazQueryArtikl:
exec sp_xml_removedocument @hDoc
Select '<errors><error code="'+cast(@nErr as varchar(10)) + '" description="' + @sError + '" /></errors>'
RAISERROR ('Greska u sp %s ! Razlog: %s ' , 16, 1,'error_spG_IzlazQueryArtikl',@sError)
return 1
GO
You are right, and SQL Server does have an inconsistent whitespace handling at the ends of some textual objects. This behavior also seems to differ on SQL Server 2000 and SQL Server 2005. At the moment the only workaround is to use the ignore whitespace option.
Regards,
Andras
Add comment
Please sign in to leave a comment.
I just run into very strange problem.
I have two stored that have two empty lines at the end on destination server. I have only one empty line on production server.
In sync script I don't have empty row, but in newly created stored I have one row.
That ever I try I get one extra line on destination server. (but just for that two stored).
Of cousse, when I check ignore white space, the stored are the same in SQL compare (but the one on destination have one empty line).
Can't reproduce error on other stored procedures, only on some.
Is I can see the sql compare script are fine (have exactly empty rows),
but SQL server 2005 Apply one more (on some very long ~600 lines) stores.
I think this is SQL server problem, but just point here at the problem .
(end of sync script loos fine, after applying script have one extra line)
...
return 0
error_spG_IzlazQueryArtikl:
exec sp_xml_removedocument @hDoc
Select '<errors><error code="'+cast(@nErr as varchar(10)) + '" description="' + @sError + '" /></errors>'
RAISERROR ('Greska u sp %s ! Razlog: %s ' , 16, 1,'error_spG_IzlazQueryArtikl',@sError)
return 1
GO