how to search for any object name in sql server [Resolved]

Posted by Sureshij under Sql Server on 2/28/2014 | Points: 10 | Views : 691 | Status : [Member] | Replies : 1
hi all, i need to search for any string which is part of object name in the sql server... for example , search string like 'LastName' where and all it is used?

ij


Responses

Posted by: Bandi on: 2/28/2014 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
simply, open SSMS and go to view menu and choose "Object Explorer Details" option
there you can search for any string to which u want the dependency objects.....

refer this link
http://blog.sqlauthority.com/2014/02/26/sql-server-find-anything-in-object-explorer-in-ssms/

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sureshij, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response