• One way to accomplish this would be to create a linked server for all servers you would like this SP to run on then create a cursor that will loop through all names in sys.servers and use the name to in dynamic sql to create the insert-exec statements. By creating linked servers, you will not have to use openrowset either, just basic insert-exec

    insert into spresults

    exec [Linked_server].[MASTER].[dbo].[SP_SQL_Server_Info_HADB_ToReport]

    If you do not want to create the linked servers then you can create a table that will have all your server names, and just have cursor loop through that, using your openrowset query.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]