title: How to save SQL stored procedures to .sql files via batch
body: <p>I woud like to save my MS SQL Server 2005 stored procedures to .sql files automatically (would prefer a tool which I can call via .bat) so I don't have to click each single sproc manually and save it.</p>
  <p>I have already found SMOscript from devio IT, but it gathers all tables and sproc which takes some time. Is there any similar tool where I can define which sproc(s) to export? Also I'm missing the <code>USE &lt;DB&gt;</code> clause which SMOScript doesn't add to exported file in contrast to the manuall export as script sproc for <code>CREATE</code>.</p>