Home Forums SQL Server 2008 T-SQL (SS2K8) Quering Code RE: Quering Code

  • May 13, 2013 at 8:45 am

    #1614635

    michael.higgins (5/13/2013)

    SELECT DISTINCT o.name, o.type_desc, p.name, p.type_desc

    FROM sys.sql_dependencies d

    INNER JOIN sys.objects o

    ON d.object_id = o.object_id

    INNER JOIN sys.objects p

    ON d.referenced_major_id = p.object_id

    Worth a try from a quick google search

    sql_dependencies is not reliable source for determining if some table is used in views or programming objects...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]