Jeff, thanks for the code set.  I will look at it over the weekend.  I like the principle of it, but one problem is that I would need to generically...

The values I provided as examples are truly real discovered values.  Since we discover over 75,000 .exe's across our cient via SMS, you can only imagine the number of versions...

Just an update on this thread.  According to the licensing agreement from MS, per processor licensing for SQL Server is set up this way. 

For the physical box, you must...

Thank you for the help.  This is exactly what I was after.

R.

Without knowing what your Pass-Through query is trying to do, I did a little searching and came across this KB article.  Not too sure if it helps in your situation,...

In my experience linking to a MySQL database, you simply surround your OPENQUERY statement in parenthesis and place it into your join.

SELECT a.*, b.* FROM tbl1 INNER JOIN (SELECT *...

My point with my last post was not about using a cursor, it was about the methadology used in the second half of the referenced article.  by following the logic...

Without having tested your queries, you might surround each query in your Stored Proc with a BEGIN...END  It may just need some identifiable separation in order to run them both.

Just...

Here is an article that discusses how to eliminate a cursor.  You could follow this model to get your recordcount. 

http://www.sqlservercentral.com/columnists/kAli/eliminatingcursors.asp

There always seems to be another way.

Rich

ok, Shaun, I know that my ODBC works because I can get data through Excel.

However, when attempting to set up a linked server using Access or SQL Server 2k5, I...

Shaun, how is your ODBC set up.  did you use DNS name of box or the IP?

I went through and set up my linked server the same as yours and...

Ok, so can you tell me how you set up the MySQL account?  What is currently happening is that I can set up the ODBC using the same version.  It...