Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Interesting MS CE bug in a .sqlce file Expand / Collapse
Author
Message
Posted Wednesday, August 8, 2012 12:17 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 4:24 PM
Points: 418, Visits: 603
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?

Post #1342114
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse