I so much enjoyed the lecture. I mean this is simply beautiful. I cannot wait to have it up and running in my environment.
I ran the query [sp_SourceTargetMapping] and then drag the Person.Person Table unto the query window after setting up the shortcut for execution but got the following error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'.
Does it matter which database is used to run the proc?
Is there anything that I should change in the s. proc e.g @tablename?
Please help out.