InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 23:14:19 GMT20http://www.sqlservercentral.com/Forums/Topic1401941-391-1.aspxThanks a lot Robert.This is great solution. I did not run it yet, I am not very proficient in Powershell, I will let you know about results.Wed, 02 Jan 2013 11:28:42 GMTSQL Guy 1http://www.sqlservercentral.com/Forums/Topic1401941-391-1.aspxattached is a powershell script I have used to script out all objects. This scripts all objects to their own file you can adjust the $Scripter.Options.FileName option. The script either accepts a text file with a list of servers or if a file is not supplied it will run with the local instance.Wed, 02 Jan 2013 10:21:03 GMTRobert klimeshttp://www.sqlservercentral.com/Forums/Topic1401941-391-1.aspxHi all,I need to automatically script out all objects from a databases similarly like in SSMS context menu in <Database>/Tasks/Generate scripts.Here is the reason for it: this is development server. I have a job where once a week I run restore from prod backup, but developers usually forget to save their work in TFS. In order to prevent losing their work, I want to script out all the contents of database priorly to restore.ThanksWed, 02 Jan 2013 09:59:08 GMTSQL Guy 1