Sql-server – Suppress SQLCMD messages

Edited: It looks like the answer is: No, you cannot create a full-text index in a system database.

You can, of course, run a script to turn on a full-text indexing after the new database is created from model, if that is necessary. But by default all user databases in the more recent versions of SQL Server have full-text indexing turned on automatically.

Note that from SQL Server 2008 forward, the sp_fulltext_database command is a no-op, just supported for script compatibility.

So, there is certainly no reason, unless your are supporting SQL Server 2005 or earlier version, to have this code included in your standard scripts. It is obsolete.

You can run the following code to see how much longer a backup or a restore will take. It also tells you how long a DBCC checkdb will take and a few other commands as well.

SELECT session_id, command, s.text, start_time, percent_complete, 
CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ' hour(s), '
    + CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + 'min, '
    + CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ' sec' as running_time,
CAST((estimated_completion_time/3600000) as varchar) + ' hour(s), '
    + CAST((estimated_completion_time %3600000)/60000 as varchar) + 'min, '
    + CAST((estimated_completion_time %60000)/1000 as varchar) + ' sec' as est_time_to_go,
dateadd(second,estimated_completion_time/1000, getdate()) as est_completion_time 
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) s