Please do not cross post, replies here please http://www.sqlservercentral.com/Forums/Topic1381095-17-1.aspx

Check out the Microsoft learning pages for the exams, they have the official recommended training materials advertised for each exam which do not infringe on the NDA.

Also you cannot have spaces in element names, <Data Extract> needs to be <DataExtract>

DECLARE @SQL NVARCHAR(MAX) = '<DataExtract><Graduates><Candidate><FirstName>Shaun</FirstName><LastName>Slabber</LastName></Candidate><Candidate><FirstName>paul</FirstName><LastName>devine</LastName></Candidate></Graduates><ExperiencedHires><Candidate><FirstName>paul</FirstName><LastName>devine</LastName></Candidate><Candidate><FirstName>Meera</FirstName><LastName>Bhana</LastName></Candidate></ExperiencedHires></DataExtract>'

select @SQL

select CAST(@sql as xml)

What is the output of @sql before you convert it to XML?

DECLARE @sql Nvarchar(max)

SET @sql = '<Data Extract>'

SET @sql = @sql + (SELECT Top 2 FirstName, LastName

FROM

[dbo].[CandPersonal] pe

INNER JOIN CandProfile...

Are you any good in shredding XML? If so, build a second data set which uses the global report name parameter and query the reportserver database for the XML...

You need to ensure that you have set the correct permissions to the folders and reports for the users you want to grant access to.

SSRS is an explicit security system...

Does this happen every day?

If so someone has changed the schedules on all of the subscriptions.

The below will help you find the subscription and then you can troubleshoot from that...

Dumps are in violation of Microsofts NDA which all candidates need to read and accept before taking an exam.

If you are found in breach of the NDA you will lose...

Yes you can do that sort of thing if you want, just need to query the correct tables to get the information out and check it against a previosu run...

sp_msforeachdb also doesnt take into account certain characters in the DB Name, so it wont work as intended if such characters exist. The methods advised of going through sys.databases...

Typically

CH4SQL1\INSTANCE01 runs on CH4N1

CH4SQL2\INSTANCE02 runs on CH4N2

CH4SQL3\INSTANCE03 runs on CH4N3

But as this is a fail over cluster, if each of the Virtual Names wasn't in the 4 nodes XML files...

If you impliment the right security at the login level to prevent people adding people into the role then yes, but remember if a user has sysadmin rights they can...

MSDN - Recovery Models (SQL Server)

Because each instance is a virtual name.

I have 4 nodes and 3 SQL instances therefore I need to have 3 names in the XML file.

CH4N1 - Is a node

CH4N2 -...

Yes, as long as you put TWONODECLUSTER in the XML file on Node1 and Node2