My mistake, sorry and thanks for the information. It is of great help.

-Kyle

The script is run as part of a BI package that is designed to run on over 100 databases. Also, selecting from the sys.* is not an option as it...

What do you mean that I can just open it? The script is run as part of a BI package that is designed to run on over 100 databases....

Quick Google Search:

discussion of microsoft ole db provider for db2 with link to download...

http://blogs.msdn.com/dotnetinterop/archive/2006/01/19/oledb-provider-for-db2.aspx

---------------------------------

That doesn't work because the server that this is running from does not use one...

The server is mixed mode. I can connect through the connection manager, so I can't figure out what could be the problem.

Thank you very much.

SQLServerCentral.com has basically helped me become one of the most efficient DBA's on my team. Now before you call shenanigans, let me tell you how SQLServerCentral.com does this. ...

Thank you very much.

-Kyle

Why does the user instance mode cause problems?  How does it become useless if someone has Standard or higher installed?

Thanks,

Kyle

What is installer?

-Kyle

This was the answer.  Thanks to all who helped.  The final query looked like this...

IF CONVERT(char(1),SERVERPROPERTY