Home Forums SQL Server 2005 SQL Server 2005 General Discussion searching for linked server references RE: searching for linked server references

  • February 6, 2009 at 2:10 pm

    #939785

    just change to a temp table, no problem:

    CREATE TABLE #LinkedServers (

    SRV_NAME varchar(128),

    SRV_PROVIDERNAME varchar(128),

    SRV_PRODUCT varchar(128),

    SRV_DATASOURCE varchar(128),

    SRV_PRIVIDERSTRING varchar(128),

    SRV_LLOCATION varchar(128),

    SRV_CAT varchar(128)

    )

    INSERT INTO #LinkedServers

    EXEC sp_linkedservers

    SELECT SRV_NAME FROM #LinkedServers

    select *

    from syscomments cross join #LinkedServers x

    where charindex(x.SRV_NAME,syscomments.TEXT) > 1

    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!