Known issues

SQL Server 2005 (all editions)

Scanning sys.messages may fail with this error in case not all language packs are installed properly:

QUERY_ERROR [sys_messages]:
Failed to load format string for error 345, language id 1033. Operating system error: 317(The system cannot find message text for message number 0x%1 in the message file for %2.). Check that sqlevn70.rll is installed in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033, where 1033 is the language ID of US English, or the appropriate folder for the locale in use. Also check memory usage.

SQL Server 2005 – 2012 (all editions)

SQL Server will throw an error when selecting from these views in case full-text isn’t installed for the instance:

• [sys].[dm_fts_fdhosts]
• [sys].[dm_fts_memory_buffers]
• [sys].[dm_fts_memory_pools]

Scanner will detect if the full-text is installed via the SERVERPROPERTY(N’IsFullTextInstalled’) and skip these views if not.

Warning will be printed out: Fulltext is not installed! Views [sys].[dm_fts_fdhosts], [sys].[dm_fts_memory_buffers] and [sys].[dm_fts_memory_pools] will be excluded from the scan.