How do I determine if I'm having a Linked Server problem in SQL between the NQCCDB and a QDB? (NETIQKB73226)

How do I determine if I'm having a Linked Server problem in SQL between the Control Center Database (NQCCDB) and an AppManager Repository Database (QDB)?

In SQL Management Studio, run the following query against the NQCCDB Database:

Select * from <hostname>.<qdb>.dbo.object

Replace <hostname> with the name of the SQL Server hosting the repository in question, and replace <QDB> with the actual repository name (which is QDB by default).

If you get rows returned, you do not have a linked server problem.  If you get an error, you have a Linked Server issue.  NetIQ is not responsible for Linked Server issues, you should work with a SQL Server Administrator or Microsoft to resolve this issue.

Formerly known as NETIQKB73226