New SQL Server project templates for VS2015 (Create Log File.sql)
1: /*
2: $DatabaseNameTemplateComment$
3: */
4: ALTER DATABASE [$(DatabaseName)]
5: ADD LOG FILE
6: (
7: NAME = [$SqlFileFileName$_log],
8: FILENAME = '$(DefaultLogPath)$(DefaultFilePrefix)_$SqlFileFileNameWithExtension$',
9: SIZE = 1024 KB,
10: FILEGROWTH = 10%
11: )
Order a job
Comments (
)
)
Link to this page:
//www.vb-net.com/VS2015-SQL-Server-Project-Templates/Create-Log-File-sql.htm
|
|