Useful FileBound SQL Scripts

1. List FileBound updates/upgrades applied and timeframe:   

select * from ScriptUpdates where ScriptName like 'SQL_Updates' order by DateExecuted desc;

3. List all FileBound version script updates/upgrades applied in descending order:

select * from ScriptUpdates order by DateExecuted desc;

2. Check to see if your MS SQL database has "Full Text Search" installed (0=no, 1=yes): 

select ServerProperty('IsFullTextInstalled') as IsFullTextInstalled;

3. List FileBound SQL udate/upgrade scripts sequentially by ScriptUpdateID

SELECT * FROM ScriptUpdates Order by ScriptUpdateID DESC