I am in the process of patching my installation of SQL Server 2005 to allow Sql Server Management Studio to connect to SQL Server 2008 servers.
According to the page (Cumulative update package 5 for SQL Server 2005 Service Pack 2
), you must enable the SQL Server Management Object (SMO) extended stored procedures and the SQL Server Distributed Management Object (SQL-DMO) extended stored procedures before you apply the cumulative update package. For more information about the SMO and DMO XPs option, see SQL Server 2005 Books Online.
On Books Online I found the following.
sp_configure 'show advanced options', 1;
sp_configure 'SMO and DMO XPs', 1;
After running the first 4 lines I was expecting to see an option available, in the Sql Server Management Studio interface, to allow me to graphically view and configure the status of the use of SMO and SQL-DMO extended stored procedures.
Should you be able to see the configuration status for SMO and SQL-DMO extended stored procedures within the Sql Server Management Studio interface or is this something that can only be configured via the execution of the above code?