How can i write polling and processing queries
i dont want to fully update the molap cache and i also dont want to fully read the source database that is why i am using polling query to poll the changes and processing query to get the changed records from database. for information about polling and processing query you can check the link
http://msdn2.microsoft.com/en-us/library/ms188965.aspx
but i am unable to write these queries to get all changes i.e insert, update and delete records can any one tell me how can i use these queries OR SQL Server provide some other way to just read the changes in source database not the whole dabatase.
[747 byte] By [ArifHasan] at [2007-12-22] 