========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
Thanks for your help. But i don't need that actually. these 20 SPs are new SPs and need to create first. So i have a Folder which contains these 20 SPs. Now i need a batch file which take the SP name from the folder and read the contents of the SP and create it in the Database.