Post reply

How can I modify Query Analyzer to be more helpful ?

  • April 15, 2005 at 1:37 pm

    #362404

    How can I make Query Analyzer be more helpful ..

    1) I would like to see line numbers on the SQL page so I can easy find an error ?

    2) How can I hide all NON user stored procedures for a database ? ie dbo.dt_

  • April 15, 2005 at 2:14 pm

    #553014

    line numbers are on the bottom of the screen. there is no way to display them on the side but ctrl-g will get you there.

    i have never seen anyway to hide non-user sprocs except in EM.

  • April 15, 2005 at 2:46 pm

    #553020

    "i have never seen anyway to hide non-user sprocs except in EM."

    How do you do this,then ???

  • April 15, 2005 at 3:26 pm

    #553024

    If you get an error in Query analyzer you can "double click" on the error message and more times than not it will take you to the offending line.

    As for hiding the non-user items - in EM, right click the server and select "Edit SQL Server Registration Properties". Now clear the check box for Show system databases and system objects.

    Hope this helps,

    Darrell

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

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