The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...

I would like to know is there a way to take a dat file and log file from one sql server and import that file to anther server. For example a customer has a dat file and log file on a cd rom and I want ...

I have a daily generated csv file that I'm going to have its contents inserted into tables in our SQL Server database. I can open the csv as a recordset in ADO, but I'm not sure how I open a second ...