ThinkingStiff
Reputation: 65341
Stop SQL Server Management Studio from adding comment to stored procedures
How do I prevent SQL Management Studio (10.50.2500.0) from adding this to the beginning of every stored procedure when I right-click/Modify them?
/****** Object: StoredProcedure [dbo].[myproc] Script Date: 11/05/2011 16:20:05 ******/
Upvotes: 5
Views: 2403
Answers (1)
fortune
Reputation: 328
Scripting options stay here : Tools > Options > SQL Server Object Explorer > Scripting.
Set "Include descriptive headers" to false.
Upvotes: 7
Related Questions
- SSMS removing pre-BEGIN comments from my stored procedures
- How do you leave comments in SQL Server 2008 R2 view with SSMS?
- How to disable comment when using SMO
- Remove SQL comments
- Stop SQL Server Management Studio from adding ANSI_NULLS and QUOTED_IDENTIFIER
- How to add header comments when altering stored procedures in SQL Server
- How to remove commented line
- How does Management Studio know to save my T-SQL comments?
- How to delete all comments from Stored Procedures in SQL Server?
- How can I automatically prepend comment blocks to SQL Server stored procedures?