Post reply

query to search through different servers

  • August 3, 2006 at 2:49 am

    #61701

    Could someone please assist me

     

    Is their a way to search through different servers I have a query that searches for an owner of objects through different  databases in a server but i want it to run through different servers please assist

    here my current query : (it works) jus need it to run through diff servers please HELP

    EXEC sp_Msforeachdb @command1 =  -- Looks through all databases on server

    "Select o.name,u.name,o.uid

    from ?..sysusers u,?..sysobjects o

    where (u.name like '%nko98766'

    and o.uid = u.uid)"

  • August 3, 2006 at 6:42 am

    #653059

    Duplicate post. Answered in other one

    Far away is close at hand in the images of elsewhere.
    Anon.

  • August 7, 2006 at 5:28 am

    #653548

    There are 3rd party tools that allow you to run a query or queries against multiple servers in parallel. See SQL Farm Combine for example, http://www.sqlfarms.com.

    Editor's Note: : Dr. Omri Bahat works for SQLFarms, a software vendor of SQL Server tools.

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

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