Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

syntax error #37

Closed
JanosBerke opened this issue Jan 16, 2021 · 3 comments · Fixed by #38
Closed

syntax error #37

JanosBerke opened this issue Jan 16, 2021 · 3 comments · Fixed by #38

Comments

@JanosBerke
Copy link

When I try to run the script I got the following errors:
Msg 102, Level 15, State 1, Line 483
Incorrect syntax near 'WITHIN'.
Msg 102, Level 15, State 1, Line 662
Incorrect syntax near 'WITHIN'.
Msg 102, Level 15, State 1, Line 738
Incorrect syntax near 'WITHIN'.
Msg 102, Level 15, State 1, Line 762
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 834
Incorrect syntax near 'WITHIN'.
Msg 102, Level 15, State 1, Line 900
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 1092
Incorrect syntax near 'WITHIN'.
Msg 102, Level 15, State 1, Line 1321
Incorrect syntax near 'WITHIN'.
Msg 102, Level 15, State 1, Line 1477
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 1648
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 1684
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 2299
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 2641
Incorrect syntax near 'WITHIN'.

@dimitri-furman
Copy link
Contributor

Thanks for testing. This is because the database is using compatibility level 100, which is not supported without a manual modification of the script. See Limitations.

We'll try to add a more descriptive error to raise in that case.

@dimitri-furman dimitri-furman linked a pull request Jan 16, 2021 that will close this issue
@dimitri-furman
Copy link
Contributor

We added a separate version of the script for databases using compatibility level 100.

@JanosBerke
Copy link
Author

Thank you 👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants