Post reply

how to find out unuseddatabase objects in sql server 2005

  • June 16, 2008 at 6:12 am

    #122138

    Hi all..

    i want to find out list of objects i.e. tables,views storedprocedures etc.. which have not been used in database directly (in query, indirecly (in application code).

    Thanks in advance..

    Regards

    vikas khirwadkar

  • June 17, 2008 at 4:25 pm

    #830110

    What you are asking can be quite a complex task, especially if application code is using dynamic SQL statements in lieu of stored procedures. That said might I refer you to the Dynamic Management Views available in SQL 2005. Look up those listed to determine if any of them will give you some of the answers you are searching for.

    The URL is:

    http://qa.sqlservercentral.com/Forums/Post.aspx?SessionID=pxttob3cwyj5tn45jvrl4sex

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply