Geek Answers Handbook

Delete date / time in SQL script generated using SSMS?

When I create scripts in SQL Server 2008 Management Studio, it seems to also insert the date and time into the script.

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 this?

+6
sql-server ssms
source share
1 answer

Tools .. Options .. SQL Server Object Browser .. Scripts

You may need to set "Include Descriptive Headers" = false

However, your question is unclear, so this is an assumption.

+9
source share

More articles:


All Articles