Thanks for your reply.But the 1st query gives me an error in Adventure Works DB:

Msg 208, Level 16, State 1, Line 1

Invalid object name 'sys.sql_expression_dependencies'.

So I tried to see if there is a spelling mistake in 'sys.sql_expression_dependencies'.

I typed .sql_expression_dependencies' in google and found this link

http://msdn.microsoft.com/en-us/library/bb677315.aspx

and copy pasted

SELECT OBJECT_NAME(referencing_id) AS referencing_entity_name,

o.type_desc AS referencing_desciption,

COALESCE(COL_NAME(referencing_id, referencing_minor_id), '(n/a)') AS referencing_minor_id,

referencing_class_desc, referenced_class_desc,

referenced_server_name, referenced_database_name, referenced_schema_name,

referenced_entity_name,

COALESCE(COL_NAME(referenced_id, referenced_minor_id), '(n/a)') AS referenced_column_name,

is_caller_dependent, is_ambiguous

FROM sys.sql_expression_dependencies AS sed

INNER JOIN sys.objects AS o ON sed.referencing_id = o.object_id

WHERE referencing_id = OBJECT_ID(N'Production.vProductAndDescription');

.Still it gives me the same error irrespective of any Database. This time I tried in Northwinds.

SAme error.