Query for Resources and Versions in MSCS_Admin

This query shows the resources and versions from the MSCS_Admin db.

USE [MSCS_Admin];
SELECT r.[s_DisplayName], r.[s_Description], r.[s_Type], rp.[s_Value]
— SELECT r.*, rp.*
FROM [Resources] r, [ResourceProps] rp
WHERE rp.[s_PropertyName]=’s_ResourceVersion’ AND rp.i_ResourceId=r.[i_ResourceID]
ORDER BY r.[s_DisplayName]

Also here is a script to create FullTextIndexes for a database:

Also Check the following thread in order to change your connectionStrings directly from db (BE CAREFUL, UNSUPPORTED BY MS)