In case of a disaster, you want to create a script to reproduce all database objects. In previous editions of SQL Server, you would have to create a script. In SQL Server Management Studio, though, you can create a:
Answer – Solution(Every change made in the graphical user interface produces a Transact-SQL script accessible by clicking the Script button in the upper left-hand corner of the Configuration screen. This script can be saved directly to a file or to the clipboard for pasting in folders in the Solution Explorer.)