I have one doubt in sql server .
how to take Script database objects automaticaly using sql script and keep into specificfoleder(c:\backup)
tables structure( create without data),views,procedures,functions and triggers backups with unique names and all are in one file and keep it into
specifice folder(current system: (c:\backup))in SQL Server.
I have tried like below using ssms manualy
: right click on database and click task...>generate scripts..>choose objects...>select entire database
and all datbase objects(tables,view,function and triggers..etc) ....>
set scripting option choos the required dirctoryname((c:\backup))and save file
please tell me how to achive this task in sql server .