Post reply

Select from all databases across multiple servers

  • March 23, 2007 at 10:12 pm

    #116824

     Hey Guys:

    I am pretty new to sql. I need help please. I have several client databases across 3 servers; datbase structures are same for all clients. I need to do a select across all datbases. How can I do that? Thanks in advance for your help.

     

  • March 23, 2007 at 10:44 pm

    #696742

    I think this takes care for all dbs in a server:

    EXEC sp_MSForEachDB 'IF ''[?]'' NOT IN (''master'', ''model'', ''msdb'', ''tempdb'')

      select top 10 ''[?]'',* from [?].dbo.individual1 o join [?].dbo.address1 c on o.ind_id =c.ind_id

    '

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

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