Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

SQL Prompt Tip #4 - System Objects

By Steve Jones,

SQL Prompt is an amazing productivity enhancement tool for SQL developers. However there are a number of features that many people are not aware of. These tips will help you learn more about ways in which SQL Prompt can speed your development. We urge you to try each of these tips out for a week or two and see if you find them helpful.

There's a link to a video demonstration of this tip as well.

No System Objects

When using SQL Prompt, system objects are not shown by default as suggestions. For example, one of the functions I often run is sp_who2. However, if I type "sp_w", I don't get any results.

I can, of course, type to whole command and SSMS colors it as a valid command, which I can then run.

I can type "sys." and then I'll see system objects, as shown below.

However, that's not what I want.

Suggesting System Objects

If I enter options dialog under the SQL Prompt menu item, I can change this in the behavior section. By default, the "List system Objects" checkbox is unchecked. However I have checked it as shown below.

Now when I type "who", I'll see suggestions.

There are a lot of system objects, so I would not change this behavior unless you work with them often.


You can see a video demonstration of this tip below from Tom Crossman, one of Red Gate's talented employees working on SQL Prompt.

Total article views: 119 | Views in the last 30 days: 4
Related Articles

Reposition parameter prompts objects

How to move around prompt objects


SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio

By default, SQL Server system objects are listed in Object Explorer in Management Studio. These syst...


SQL Prompt Tips #1 - Selecting in the Object Explorer

A quick tip to help you get the most out of SQL Prompt


Objects, Relationships, Systems, And Processes

What is the difference between an expert DBA and a Master DBA? This piece from William Talada talks ...


Important: System Objects/Views/DMV/DMF

Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF...

sql prompt    

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones