Just a quick post to show, how to loop through all tables and columns in database and find all occurrences of the keyword specified – /*Declare variables */ Declare @Keyword varchar(200) Declare @CountTable int Declare @Loop int Declare @DbOwner varchar(50) Set @Loop = 1 /*keyword to search for */ Set @Keyword = report /*Owner of [...]
Another challenging day (June 10th, 2011), opted for Microstrategy v9 exams and finally managed to crack it. For more information on Microstrategy education and certification refer to http://www.microstrategy.com/education/Certification/