Home Forums SQL Server 2008 SQL Server 2008 Administration creating table on all sql servers in the environment RE: creating table on all sql servers in the environment

  • September 17, 2013 at 8:23 am

    #1650811

    Jack Corbett (9/16/2013)

    You can create a server group in SSMS (Registered Servers tab), right-click on the group and select new query. Then the query will be run against all the servers at one time. As long as the database you are creating the table in has the same name it will work. You can see an article about mult-server queries here.

    You could also use PowerShell, but I think a multi-server is query the way to go.

    Thanks Jack for your response. I need to drop and create this table and insert some values for every month....so its kind of automated process.....i believe we can achieve this through powershell....please post your ideas...thanks in advance...