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.