Hello Jeff. I realize that you posted this reply over a year ago, but I was having the same problem and went digging through Forums to see what I...

Thank you to all those that replied. The single quote twice works the best in my particular environment. Perfect!!

Thanks again!

Sophie

Hello! I too used to use Insert statements to get my data from Excel into SQL, however, I have had to move away from this process (to using the...

Well, I seem to be having the same bad luck.  I also installed SP2 and the dropdown has exactly the same choices as before.  It appears we have come full...

Thanks Anders... you're right, it's in SP2.  I'm having my guys install it this afternoon.  The line reads:  Generate Script Wizard. You can now specify that the scripted objects include...

I would very much like to see the answer to your above stated question.  I have run into the same problem (it applies to tables and procedures as well).  I...