Remove the date/time in SQL script generated using SSMS?

sql-server, ssms

Solution

Tools.. Options.. SQL Server Object Explorer..Scripting

Probably need to set "Include Descriptive Headers" = false

However, your question is unclear so this is a guess.

Problem

When I generate scripts in SQL Server 2008 Management Studio, it seems to insert the date/time in the script also. For example: ``` USE [AdventureWorks] GO /****** Object: View [dbo].[vw_test] Script Date: 18/01/2017 3:27:10 PM ******/ SET ANSI_NULLS ON GO <rest of script goes here> ``` How can I remove that?

Original source