Post reply

Incorrect Syntax

  • September 17, 2003 at 6:59 am

    #82586

    I am getting the following error message while trying to run some scripts from here:

    Server: Msg 170, Level 15, State 1, Line 1

    Line 1: Incorrect syntax near '703'.

    Is there an option that's not right?

    Line 1 just has a "---------".

    Scott

  • September 17, 2003 at 7:13 am

    #474627

    Which scripts do you mean, from the scripts section or from posts. If you are copying and pasting from posts you have to check the formatting, not all code will work directly from copying and pasting. Can you quote an example.

    Edited by - davidburrows on 09/17/2003 07:13:38 AM

    Far away is close at hand in the images of elsewhere.
    Anon.

  • September 17, 2003 at 8:11 am

    #474644

    I found the problem. We have some databases that started with number like '703' and one had a '-' in the name.

    In Jeff Weisbecker GetFileInfo2, the USE and SELECT needed a [ ] around the db name to work properly for us.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply