Changing Folders in Query Analyzers Object Browser

• dean gross

  SSCrazy

  Points: 2632

  More actions

  July 27, 2004 at 7:53 am

  #161196

  Is there any way to add additional folders to the object browser in Query Analyzer (SQL Server 2000 SP3) or to change what is displayed in each folder? I would like to move or filter out the system stored procedures from the Stored Procedure folder so that I can more easily find my own procs.

  Thanks

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  July 27, 2004 at 9:01 am

  #516325

  Prefixing anything other than SP_ should help - you should avoid doing this anyway due to certain query plan execution problems.

  I'd be tempted at ASP_ to get them at the start - but then they look like web based objects.

  MVDBA