If you mean a seperate mdf or ndf for each sp or whatever its technically possible but not logical. Another case for every object in the database you can make a script file. But those files are just to store the scripts, not for executing them from where they are placad. Just right click on any database then Tasks -> Generate Scripts

Zubeyir