hmmm,
can't get it to work. I have SP5 installed on BES but cannot get the SQL scripts to execute. I ran from the commandline on bes and got:

[20000] (06/09 18:24:04.496):{0x11E4} Database name: BESMgmt
[40000] (06/09 18:24:04.496):{0x11E4} Authentication Type: Database Authentication
[40000] (06/09 18:24:04.496):{0x11E4} DBMS Type: SQL
[20000] (06/09 18:24:04.590):{0x11E4} Database connection opened!
[20000] (06/09 18:24:04.590):{0x11E4} Reading input file: EnableRichContent.sql
[40000] (06/09 18:24:04.590):{0x11E4} ----------------------------------------------------------------------------
[40000] (06/09 18:24:04.590):{0x11E4} -- EnableRichContent.sql
[40000] (06/09 18:24:04.590):{0x11E4} --
[40000] (06/09 18:24:04.590):{0x11E4} -- This will turn on the Rich Content options for all
[40000] (06/09 18:24:04.590):{0x11E4} -- BlackBerry Enterprise Servers managed in the target database.
[40000] (06/09 18:24:04.590):{0x11E4} --
[40000] (06/09 18:24:04.590):{0x11E4} -- (C) 2008 Research In Motion Limited.
[40000] (06/09 18:24:04.590):{0x11E4} ----------------------------------------------------------------------------
[40000] (06/09 18:24:04.590):{0x11E4} UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
[40000] (06/09 18:24:04.590):{0x11E4} UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
[40000] (06/09 18:24:04.590):{0x11E4} UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
[40000] (06/09 18:24:04.590):{0x11E4} UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
[40000] (06/09 18:24:04.606):{0x11E4} ExecuteStatement: Unable to run the statement:
----------------------------------------------------------------------------
-- EnableRichContent.sql
--
-- This will turn on the Rich Content options for all
-- BlackBerry Enterprise Servers managed in the target database.
--
-- (C) 2008 Research In Motion Limited.
----------------------------------------------------------------------------
UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
[40000] (06/09 18:24:04.606):{0x11E4} ExecuteStatement: Error: [ADOConnectionItem::ExecuteUpdateSQL(): Could not execute SQL Command "----------------------------------------------------------------------------
-- EnableRichContent.sql
--
-- This will turn on the Rich Content options for all
-- BlackBerry Enterprise Servers managed in the target database.
--
-- (C) 2008 Research In Motion Limited.
----------------------------------------------------------------------------
UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0".]
[10000] (06/09 18:24:04.606):{0x11E4} Problem occured while executing SQL commands.


So I when to the SQL server, which is 2000, selected BESMgmt and I opened the query analyser. I pasted the first line in and it failed as follows :

Server: Msg 512, Level 16, State 1, Procedure ServerConfigSaveCapTrigger, Line 29
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.


Any ideas guys?

thanks
Steve