Post reply

SQL Server Dependencies

  • February 25, 2005 at 4:28 am

    #85543

    I am a bit concerned about the effect of amending the table schema of one of our live SQL Server Databases.

    I have to delete a number of fields from one of the Data Warehouse tables.

    I have identified  any Stored Procs, UDFs' and Views that use this table by using SQL Digger.(Very Useful)

    My concern arose when I amended the table schema in a Test database.

    After I amended the table schmema I checked the dependencies via Enterprise Manager and Query Analyser and they no longer show any dependencies?

    I am concerned if I do this on the live table that my dependencies will be lost? 

    If so I take it any Stored Procs, UDFs' and Views would still run as normal?

    Is there any adverse effect from the dependencies no longer displaying?

    Any help would be appreciated

     

    Carl

  • February 25, 2005 at 8:37 am

    #544176

    Check this out.

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;115333

  • February 25, 2005 at 8:43 am

    #544180

    I take it even though I can no longer see the dependencies that there are no other problems associated with this?

     

    I have tested by dropping the table on a test server an recreating and even though there are no dependencies displayed for the table the associated stored Procedures still run fine.

     

    If I do lose the dependencies I don't necessarily need to recomiple the stored procs to make them work do I?

     

    Carl

     

  • February 25, 2005 at 9:17 am

    #544190

    The dependencies are displayed from the sysdepends table. you don't have to recompile the procedure. SQL server will take of re-compilation after you make changes(drop/re-create) the objects referenced

Viewing 4 posts - 1 through 3 (of 3 total)

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