February 9, 2007 at 3:15 pm
Hello,
I created a table creation script in SQL Server 2005 Management Studio by right-clicking on my database's name and selecting Tasks, Generate Scripts... and using the wizard. I selected some options including Script for Server Version SQL Server 2000.
When I ran the script in SQL 2000, however, I got this error:
Server: Msg 170, Level 15, State 1, Line 38
Line 38: Incorrect syntax near '('.
Has anyone else seen this error? I figure I can tinker with the script until it works, but I want to know if this is a known issue with an obvious fix. It seems wrong that SQL Server is generating scripts that trigger syntax errors where no obvious ones seem to exist.
Thanks for any help,
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
February 11, 2007 at 10:47 pm
Post the script...
May be you are using new datatype which is introduced in 2005...
MohammedU
Microsoft SQL Server MVP
March 10, 2007 at 8:23 am
was the object you generated a script from in a 2000 or 2005 db? if 2005, then what you are trying to do is not supported.
---------------------------------------
elsasoft.org
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply