Create separate file for Procedure

  • Hi All,

    Is it possible to create separate file(s) for each Function/Procedures/Views in a Database?

    If yes, tell me how is it possible.

    Thanks in advance

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply