Home Forums SQL Server 2008 SQL Server Newbies Run a query against registered servers and insert results into table RE: Run a query against registered servers and insert results into table

  • stebennettsjb (3/6/2012)


    Hi,

    MarkusB:

    Thanks for the link, i had found it while doing my own searching, but i hadnt found a way to insert into a table..

    S

    What exactly is your problem? If I run the following code the Insert works just fine for all the selected instances.

    CREATE TABLE #T

    (Server sysname, Version nvarchar(2000))

    go

    INSERT INTO #t (Server, Version)

    select @@ServerName,@@version

    [font="Verdana"]Markus Bohse[/font]