You've got a great idea here and I really appreciate all the effort you've put into your documentation - enough that I feel guilty about asking what is probably a dumb question but here goes: I've installed the latest version of MAPS and successfully
run the discovery against my SQL server hosts. In your entry
http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=318, you essentially say:
> USE MDW;
> INSERT INTO [MDW].[servers].[system] (<stuff>)
> SELECT <stuff> FROM MAPS.dbo.devices
but when I try that I get an error as I am not able to select against the MAPS database.
> SELECT * FROM MAPS.dbo.devices
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'MAPS.dbo.devices'.
What do I need to do to configure my SQL 2008 instance to query the MAPS tables in the SQL Express instance?