Server was not down, and errors occur maybe once or twice a week at different times. The job has stopped running twice at 2 p.m. though so I'm going...

I'm getting the error too on a snapshot job. The job stops mysteriously with that error and doesn't run for a few hours then starts working again. Snapshots...

If you use linked servers to other systems like Oracle or IBM, you'll notice that about half of the drivers are missing on a 64-bit server. One in particular...

As a side note, once you get the problem solved I suggest that you do not use the 'sa' account and hardcoding the password in a config file. This...

Yes, it's a bit hidden. Under Configure Subscibers,Publishers Distribution go to the Publishers tab, and hit the elipsis button for the distributor. You may see that it's using...

Think of this scenario. A company purchases a 3rd party product and the vendor installs the software, IIS, and database server onto one server. They add an NT...

We actually use this method. I create snapshots at the "top of the hour" so people know that the data is refreshed then. Just make sure not to...

Out of curiosity, why do you need to pull data out of a Teradata data warehouse? Performance? I just wondered because we have a new Teradata data warehouse...

Linked server name: Whatever

Proider: oracle provider for OLE DB

Product name: MSDAORA

Data source: Servername.xxx.xxx.net

The connection failed with just the server name but when I changed it to the fully-qualified...

I was also able to create a linked server to the AS400 with the iSeries 64-bit driver. It appears that the solution to linked servers on x64 servers is...

I was able to install the Oracle 64-bit drivers and successfully created a linked server using Oracle Provider for OLE DB. Make sure you uninstall any older Oracle products...

Did you ever get a solution from Microsoft? I am attempting to create the linked server again and am still getting nowhere. I tried creating the link in...

Brandie, the database server I am attempting to link to is a clustered SQL 2000 and the source database server is a clustered SQL 2005. There is a different...

Adam, interesting article but it addresses distributed queries and I can't even create a good link 🙂 I'll keep an eye out for this bug though. Thanks.

You are so right--I should have noticed that. (I couldn't see the forest because of the trees....) Anyway, the SQL Server settings are correct but I still see...