That "could" be your problem in that you are using 2008 R2 version of SSMS with 2008 server.

Well... I think you have to find out why SQLyog works and the native client does not. Therein lies your answer.

What version of SSMS are you using to connect?

No worries, it just gets a bit in the way for those focusing on 2008. You are also more likely to get the proper help in a 2000 forum...

Are all of your indexes recreated on the new database? Maybe a table not directly accessed through your query, but through the function?

Hi Laura,

We appreciate your post, but this really should not be in the SQL Server 2008 area. Hopefully a moderator can move this to the proper area.

Ha! Now you go to a MySQL forum 🙂

HowardW (2/7/2012)

---

Is this what you're after?

SELECT ROW_NUMBER() OVER(ORDER BY columnA desc)

rn, columnB, columnC

FROM (SELECT TOP 10 * FROM #tableA ORDER BY columnA DESC) a

The key is that you need...

Totally understood 🙂 Let me think on this a bit more...

You are in an SQL Server 2008 forum, is that the version you are on? Or are you saying it is not compatible with your MySQL database version?

Hmm... Maybe try the 5.1 ODBC for MySQL? Seems to be some issue with the conversion of data.

SGT_squeeqal (2/6/2012)

---

Bring you results into a cursor and then use rowcount -1 row to delete like for example, this will then delete all your duplicate rows bar 1

declare @col1 datatype,

@col2...

That would be quite impossible as you cannot backup a transaction log for a database in simple recovery mode. The maintenance plan does not "change" unless you change it....

Wait a minute... How did you configure the linked server? Did you select the MySQL ODBC driver or did you use something else?

And what happens if you run this?

SELECT TOP 10 *

FROM openquery(MySQL_DB, 'Select * from DB.table LIMIT 0,10')

So far, it seems to not want to close the connection. Not...