• Basically what I am trying to get is open 99 sessions of SQL server and run some queries in each session.

    But I dont want to open 99 connections manually.I am looking for some TSQL script or batch file which can do it.

    I gave example queries in my original post.

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.