Get the list of all stored proc in .net application RRS feed

  • Question

  • Hi All,

    I have a task i want to remove all the unused sp, table,function view in a application which is in .net

    can any one tell me the fast and effiecient way to do this .


    Shivesh Kumar jha

    • Moved by Bob Beauchemin Friday, January 18, 2013 5:42 PM Moved to the appropriate forum for SqlClient applications
    Friday, January 18, 2013 9:44 AM

All replies

  • Hello Shivesh

    How do you define "unused" object?

    You can query the different object over the system views, example for SP + tables:

    SELECT *
    FROM sys.procedures;
    SELECT *
    FROM sys.tables;

    Olaf Helper

    Blog Xing

    Friday, January 18, 2013 10:00 AM
  • Since this is a .NET application question, I'm moving it to the forum for .NET applications. You need to figure out a way to decide which objects are "unused" and define what you mean by unused, T-SQL or .NET does not provide that.

    Cheers, Bob

    Friday, January 18, 2013 5:42 PM