SQL server problems scripting database
Posted on 2009-07-02
I am trying to script a database by using the Microsoft SQL Server Management Studio.
I right click on the database > Tasks > Generate scripts.
I then select "Script Data" to true so it scripts all of the database.
I then put that Generated SQL statement into the SQL query window and execute. Everything is fine apart from 1 field in 1 table.
It's throwing an error.
Msg 105, Level 15, State 1, Line 92
Unclosed quotation mark after the character string 'Canon
Msg 102, Level 15, State 1, Line 92
Incorrect syntax near 'Canon
This field is of varchar type and stores 25 characters. I think there is a problem with the quotation mark, when i cursor left or right over the data it always gets stuck on the quotation mark and i have to press the cursor on the keyboard twice to get over it. The find and replace also cannot pick up the quotation mark.
if i coped and pasted that into here it would only copy N'Canon
Does anyone know anything about this? I have never come accross this before :~
Thanks in advance.