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

Posted by Sureshij under Sql Server on 2/28/2014 | Points: 10 | Views : 1376 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts