Tuesday, 3 January 2012

How to get list of database objects for finding specific tables used in storedproceure or functions

select distinct B.name from syscomments Ainner join sys.objects B on A.id =B.object_id where A.text like '%tablename%'

No comments:

Post a Comment