Post reply

How to create batch file to execute a query at a time to all instances...

  • February 16, 2012 at 5:30 am

    #391572

    I want to know that i need to create batch file to execute a query to all instances at a time.

    In my environment I have 10 instances. Plz give me navigation to create batch file execution.

  • February 16, 2012 at 5:36 am

    #1447789

    you could use a central management server to execute the same query across multiple servers in one go, or if you want to do it in a batch file take a look at SQLCMD command line utility

  • February 16, 2012 at 8:30 am

    #1447936

    thats fine but I want to execute one query in all the instance at a time so that I need to prepare a batch file. Plz give me senario to prepare batch file..

  • February 16, 2012 at 8:41 am

    #1447947

    you want 1 query executed against 10 servers at the same time?

    so going back to my original post, use a central management server or create a batch file which uses SQLCMD using the -i paramater which passes in a .sql file which has your query

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

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