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.