Finding Objects in SQL server

Sometimes it is very hard to finds objects, view or tables used by stored procedure or view.

here is script which is used to find the objects from sql server.

Query Two system tables :

1. sys.objects : to find the object

2. sys.comments : to find the right text.
select  obj.name, comm.text from sys.syscomments  comm  inner  join sys.objects obj on obj.object_id = comm.id where  comm.text like  ‘%your text goes here%’

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s