A good example of this can be found at:

http://www.sqldts.com/246.aspx

I don't know if he solved the problem, but I would try OpenQuery such as;

DBCC TRACEON(8765)

select *...

Depending on the task, table locks could slow this down slightly. Otherwise running parallel tasks is usually a good way to take advantage of multiprossors. It is important to have a...

You should be able to do this with a sql server job. Just schedule it to run a stored procedure at Midnight to update your table.

I have not done this recently but I believe that I had to install the sybase ODBC driver on my SQL Server machine. Some information might be helpful at:

http://www.sybase.com/detail?id=1008930

Good Idea, Thanks

Thanks for the replys. 

This is what I am trying to do. This data is generated by a manufacturing line we received from Germany. The line can build up to...

I was working on a similar problem and that worked for me. Thanks.

Because the copy jog is failing, make sure that you are backing up the log to a share that the secondary has rights to. You should be able to browse...

In my experience, the prepare statement is not used by multiple connections or applications. When a prepare was sent to the server, a Handle was assigned to the application and...

We are doing it on two different domains without trusted relationship using SQL Server authentication.

connecstring = "driver={SQLServer};

server=000.000.000.000\instance_name;uid=sqluser;

pwd=sqlpassword;database=userdatabase"

Have you tryed using IPAddress\SQLName in your connection string? This should work as long as you are set up for Windows and SQL Server authentication.