Thanks a lot !!

Thanks a lot !!

Thank you All, your valuable response worked for me. 🙂

thanks for giving a try. I got it..

I had made a small change and now i got the output perfectly..

In the select statement i had actually changed EM.emptype_id to ET.emptype_id

SELECT...

@sean Lange..

changing the order also didnt helped..

no.. left outer join did'nt helped..

hi

there is a view sys.objects which will return you all the information about trigger ,proc , key ,view , function etc which is dependent on particular table.

all...