Can we run 4 Stored Prcocs with same parameters in parellel

You might be able to do this client side, but by submitting four requests on four separate threads, or using asynchronous methods. There is no T-SQL solution for this.

---

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se