Backing up SP's and Functions...

Hello,

I want to write a batch file which gets the backup of the SP's,Functions,Views and Tables which belongs to me.Is there a utility to do this?

The best option may be using one of the excellent third party products. Or, try these scripts and see if you can convert one of them for your usage.

DDL -Script Database to File
http://www.wardyit.com/blog/blog/archive/2006/07/21/133.aspx
http://www.sqlteam.com/publish/scriptio
http://www.aspfaq.com/etiquette.asp?id=5006
http://www.codeproject.com/dotnet/ScriptDatabase.asp
http://www.nigelrivett.net/DMO/DMOScriptAllDatabases.html
http://rac4sql.net/qalite_main.asp

I'd recommend one of the third party products, such as SQL Script from www.ApexSQL.com.

sql