if (select @@version) like '%2005%'
Begin
    --    Get List of Databases
    declare kerser1 cursor fast_forward for
    select
        name
    from 
        master.sys.databases (nolock)
    order by
        name

    if not exists (select * from tempdb.sys.objects where name like '#LinkedServerDependencies__%' and type = 'U')
    BEGIN
    create table #LinkedServerDependencies (
            [Database] varchar(100),
            [DependantObject] varchar(100),
            [LinkedServer] varchar(100))
    END

    open kerser1

    declare @sp_db_name2 varchar(100)
    declare @sp_srv_name2 varchar(100)
    declare @sql2 varchar(8000)

    fetch next from kerser1 into
        @sp_db_name2

    while @@fetch_status = 0
    Begin
        --Get List of Linked Servers
        declare kerser2 cursor fast_forward for
        select 
            name 
        from 
            master.sys.servers (nolock)
        where 
            is_linked = 1
        order by 
            name

        open kerser2

        fetch next from kerser2 into
            @sp_srv_name2

        --    Populate Table of Dependencies
        while @@fetch_status = 0
        Begin
            set @sql2 = 'insert into #LinkedServerDependencies 
                         select '''+@sp_db_name2+''' as [Database], 
                                name as DependantObject, 
                                '''+@sp_srv_name2+''' as LinkedServer 
                           from '+@sp_db_name2+'.sys.objects (nolock) 
                          where object_id in (select object_id 
                                                from '+@sp_db_name2+'.sys.sql_modules 
                                               where definition like ''%'+@sp_srv_name2+'.%'')'
            exec (@sql2)

            fetch next from kerser2 into
                @sp_srv_name2
        End

        close kerser2
        deallocate kerser2

        fetch next from kerser1 into
            @sp_db_name2
    End

    close kerser1
    deallocate kerser1

    --    Return the results
    select * from #LinkedServerDependencies

    drop table #LinkedServerDependencies
End