I am creating a view in SQL Server 2014 and using open query to link back to a query in MYSQL the dataset is over 100k lines and I keep getting time out issues from the MS SQL server. The view runs fine in MY SQL. Is there another way to do this?
FROM OPENQUERY (server, 'SELECT * FROM database.viewname AS New Name
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.