I'm using an ODBC connection to connec to a data source to import data into SQL Server 2005. I have no problems setting up the connection and the data transfer works fine on a small sample of data (doing a SELECT TOP 100 * FROM <table>).
This issue is that when I try to pull down the full table, I get a timeout on the ODBC connection. I've turned on the 'Save long running queries to the log file' and tried to change the 'Long query time (milliseconds)'. Problem is the maximum value I can enter in this field is 99999 which is only 99 seconds. I've also tried entering 0 thinking that would be the unlimited setting. Neither of these options work.
Is there anything I can do?
Note: This is a one time data transfer and I really do not care if it take 3-4 hours to run as the total table contains almost 1 million records
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
If you get continual lockouts after changing your Active Directory password, there are several possible reasons. Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…