Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-03 : 07:44:16
|
| Arjun writes "Hi,I restored database from SQL server 7.0 to SQL server 2000, I have changed the Compatibility Level to 70, there are some jobs that throughs me error like Line 1: Incorrect syntax near ','. [SQLSTATE 42000] (Error 170). The step failed.same is working fine in SQL server 7.0, i again changed Compatibility Level to 80 still the same error, I changed QUOTED_IDENTIFIER set to off and still the same error..." |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-10-03 : 07:53:38
|
| Quoted identifiers will not do you any good when the problem is a comma. There is most likely a sql-statement error in a jobstep that doesn't validate properly. Copy the job step to query analyzer and try debugging from there. Maybe you have a comma after the last colmn in a select or something.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2006-10-03 : 16:44:53
|
| Can you show me the syntax whatare executing!!!With RegardsBSR |
|
|
|
|
|
|
Line 1: Incorrect syntax near ','