Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Exploring SSMS - Filtering object names

Jul 29 2011 2:48AM by Madhivanan   

As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. In this post we will see how to filter the objects in the object explorer.

Suppose you have many tables in the database and you want to list out only the tables contain some specific word say "emp". Instead of scrolling all the way to identify them, you can apply filter options to list out them.

Follow these steps

Databases-->Your_db-->Tables-->Filter--Filter Settings

Filter settings window will be shown where you can enter emp at the value column of the first row (where property is Name) and Click ok.

Other posts that come under Exploring SSMS
Enabling Save Changes
Enable/disable intellisense
Connecting to msdn forums or submitting your feedback to connect

Tags: sql_server, sqlserver, BRH, SQL Server, #SQLServer, SSMS, #BI, filter, BI,

2 · 40% · 13039
2 Readers Liked this
Adam Tokarski Liked this on 4/2/2012 7:07:00 AM
Madhivanan Liked this on 5/18/2012 2:55:00 AM
Profile · Blog · Facebook · Twitter


Your Comment

Sign Up or Login to post a comment.

"Exploring SSMS - Filtering object names" rated 5 out of 5 by 2 readers
Exploring SSMS - Filtering object names , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]