I know you can create Main procedure and call the other procs from there. But it get's executed sequentially. I have a scenario where I have to execute say 3procs at the same time?
You'd have to be able to spawn processes and run this. You could probably do this with a batch file or issue a few commands in xp_cmdshell that were like this:
start isql -S DENWSOS1 -E -Q"select * from sysobjects"
This will spawn a separate thread (may be process, not clear and don't feel like looking) so the original item can run somehting else.