Post reply

Find stored procedures giving errors

  • June 4, 2008 at 10:29 am

    #183049

    hi guys i have a question, we made a couple of changes in some tables in the database, we have a couple of stored procedures giving us error due to this. Is there a way to test with the profiler the stored procedures that are giving us error? Maybe i could run the application to run some forms and see what the profiler says. So i could modify them? if so which events and columns should i put in the profiler? or is there another way?

  • June 4, 2008 at 11:04 am

    #824349

    Your correct. You can use the profiler for this case. Catch the below events and columns.

    Events

    RPC: Completed

    SQL: Batch Complete

    Columns

    TextData

    Any other columns would you think is necessary.

    Apply some filters so that you will not get unwanted entries. Eg: Database name, loginName, etc

    Susantha

  • June 4, 2008 at 11:06 am

    #824351

    thanks, should i also include the error and warning events ? the error i am looking for is for ambigous joins.

  • June 4, 2008 at 11:12 am

    #824355

    Not necessarily. Once you get the error, your application will stop at that point thus you can refer the profiler output to see that last entry. (assuming unwanted entries will not capture).

    Then use that sp in SSMS and manual execute it then troubleshoot.

    Susantha

  • June 4, 2008 at 11:42 am

    #824382

    Thank you so much!

  • June 4, 2008 at 3:13 pm

    #824553

    Another way would be via DBPro's schema view. It's a lot easier to identify which objects in the project become invalid due to any kind of change(s). If you have access to it...you should use it. It's an absolute beauty.

    The vision must be followed by the venture. It is not enough to stare up the steps - we must step up the stairs. - Vance Havner

  • June 4, 2008 at 3:14 pm

    #824555

    i have redgate data compare, can i use that?

  • June 4, 2008 at 3:28 pm

    #824567

    Data compare is to compare data not structure. To compare structure you could use Red gate's sql compare...but again the main idea of this tool is to give you differences between 2 instances of the database. I am not sure if it will highlight that these set of objects are invalid although it will definitely show up during the compare.

    The vision must be followed by the venture. It is not enough to stare up the steps - we must step up the stairs. - Vance Havner

  • June 5, 2008 at 7:08 am

    #824776

    is there a way to download a trial version of DBPro's schema view? I have visual studio 2005

  • June 5, 2008 at 8:12 am

    #824824

    Schema View is a feature in DBPro. You need to install DBPro (VS 2005 Team Edition for DB Professionals) for that.

    The vision must be followed by the venture. It is not enough to stare up the steps - we must step up the stairs. - Vance Havner

Viewing 10 posts - 1 through 9 (of 9 total)

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