KB Update SQL Tool - Using the tool in specific scenarios
This section provides a detailed description of how to use the tool in specific scenarios. Examples are provided using SQL queries and are not intended to be exhaustive – i.e. you should be able to create your own queries to handle any situation you face using the details described here. Each scenario is split into various sub-sections, the first explains how to manage objects that have an OBJECT_GUID, the second and subsequent section explains how to manage objects that do not have an OBJECT_GUID.
Info
Note that some of the examples use the OBJECT_NAME value from the CTV_GUID_OBJECTS view to determine the object. In some cases, multiple objects can have the same OBJECT_NAME. As such, any modifications you make to the CAST Analysis Service using the OBJECT_NAME value may change multiple objects. If multiple objects have the same OBJECT_NAME, CAST recommends one of the following:
- Using the OBJECT_FULLNAME value in the CTV_GUID_OBJECTS view as this is unique
- Using the OBJECT_GUID value in the CTV_GUID_OBJECTS view as this is unique (this value is not available for all objects however - see GUID_OBJECTS in CAST Analysis Service entry tables for more information about this.)