Home Forums SQL Server 2005 Administering How to Create Linked Server for a MySQL database using SQL Server Management Studio RE: How to Create Linked Server for a MySQL database using SQL Server Management Studio

  • Jim,

    Thanks a lot for kickstarting me.

    I got it to work using the following!

    eg. Select * from LinkedServerName...TableName

    Your example was close, but just needed the extra period.

    You can't imagine how much code that saves me and having to use temp tables.

    Very cool.

    Thanks,

    Joe