• an example of checkign the references HanShi mentioned:

    --Objects:

    SELECT objz.name,

    fn.*

    FROM sys.objects objz

    CROSS APPLY sys.dm_sql_referenced_entities(schema_name(schema_id) + '.' + objz.name,'OBJECT')fn

    WHERE referenced_entity_name ='all_data'

    and just in case, you can check the definitions of all objects as well:

    select OBJECT_NAME(object_id) As ReferencingObject, *

    from sys.sql_modules

    where definition like '%all_data%'

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!