May 8, 2006 at 1:08 am
Hi
I have machine with both SQL 2000 and 2005 instances.I had written the script in SQL 2005 management studio editor for SQL 2000 database. The scripts work fine when I open the script from word pad and paste it on SQL 2000 editor, but the same script is giving syntax error when opened in notepad or from sql 2000 editor..
Putting some tabs & Enter, makes script working (i mean no logical error is there in the script) ..Does any one face such issues ?
Is it bug in sql 2000 editor ? pls guide me on same
Regards
Shrikant Kulkarni
May 8, 2006 at 6:31 am
I don't know of any bug in the editor that would cause the behavior you're having. Since Notepad is a pure text editor, while word pad is a mini-word processor, I'm guessing that you have something along the lines of a hard vs. soft character return issue, or some other formatting issue, and that the CR is therefore not present when copied into Notepad or Wordpad.
Keep in mind that the SQL editor has no problems with vast amounts of white space, but it can't fix two separate words that have been joined together as one due to the lack of soft carriage returns, for instance. Your best bet is to either print it in Wordpad, then after copying to Notepad or the SQL editor, ensure that the copied text isn't formatted differently, or you could first paste it into Notepad, then from there paste it here, along with the syntax error you get. It should be easy for someone here to find the problem quite quickly to help you out.
May 8, 2006 at 7:50 am
In SQL Server 2005, you have the option of scripting the stored procedure for SQL Server 2000 format, generate the script using the wizard and try opening from your editor and see if its still generating the errors.
Prasad Bhogadi
www.inforaise.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply