SQLNAMESPACE object in YUKON
Problem:
From the past times we have been using DMO to create SQL Server jobs on SQL Server instances. For SQL Server 2000 and older versions like 7.0, our dependency was in huge amount onSQLNamespace functionality to make up the scheduled job property dialog box(SQLNamespaceObject.ExecuteCommandByID(.)). this is possible when the end user is having SQL client tools installed on the same machine as our client application. However, if he hasSQL Server 2005then SQLnamespace objects are not available for use. I came to know that people can redistribute thesqlnamespace DLLs with their application, But the problem is that they they have to know which DLLs to include and register. I want to achieve the same. So I've attempted this and have been facing failures all my life.
I will be very grateful if any1 tells me what are the DLLs that must be included, where they must be located and in which order the DLLs must be registered?
Thanks in Advance
Shaun
