SQL Server Performance

Line Numbers in SQL 2000

Discussion in 'Getting Started' started by David98, Nov 3, 2009.

  1. David98 New Member

    Having to go back and use SQL Query Analyzer 2000 and can not remember how to turn line numbers in Editor screen. Thank you for your help. David
    David98, Nov 3, 2009
    #2

  2. Luis Martin Moderator

    Welcome to the forums!.
    At the button of the results screen in Analyzer you have line number and column position.
    Luis Martin, Nov 3, 2009
    #3

  3. FrankKalis Moderator

    If there is no special reason, you could use SSMS to connect to 2000 and modify objects.
    FrankKalis, Nov 3, 2009
    #4

  4. David98 New Member

    Note sure what SSMS is.
    David98, Nov 4, 2009
    #5

  5. Adriaan New Member

    SQL Server Management Studio - iow the 2005 version of Enterprise Manager.
    Adriaan, Nov 4, 2009
    #6

  6. David98 New Member

    Unable to install any software on PC. So all I have is Enterprise Manager and Query Analyze.
    David98, Nov 4, 2009
    #7

  7. Adriaan New Member

    Nope, not available in EM.
    The line numbers are of limited value though. The on-screen numbering depends on SET options, USE statement, GOs, and any system-supplied comments, included before the start of the actual definition script.
    This numbering may not correspond to the line number returned in a run-time error message. And sometimes errors refer to a line where the last or next bit of sensible information is located, before or after the problem area.
    Adriaan, Nov 4, 2009
    #8

  8. Madhivanan Moderator

    [quote user="David98"]
    Having to go back and use SQL Query Analyzer 2000 and can not remember how to turn line numbers in Editor screen. Thank you for your help. David
    [/quote]
    Why do you need a line number?
    I dont think you can gain anything actually with that
    Madhivanan, Nov 6, 2009
    #9

Share This Page