Interesting MS CE bug in a .sqlce file

  • We have several insert statements to fill this DB that are generated using automated exports from our SQL server for CE to distribute. When this script is executed from code it works because it is executed using a .NET reader. When you run it manually from SSMS it does not work. It seems to be a bug in SSMS for compact. The bug is not in the insert statement. It is in the comment.

    This type of comment works

    --****************************************************************************************************************************************************

    --New Stuff

    What does not work is:

    --****************************************************************************************************************************************************

    --New Stuff ' s

    The tick makes it act goofy in SSMS. All the insert statement are passed up below that statement. Seems crazy but when you take that tick out it worked.

    Anyone know why?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply