SQL Server Discovery

Better, faster, cheaper ...pick two.
posts - 14, comments - 80, trackbacks - 0

February 2006 Blog Posts

Linked Server to Teradata - SQL2000

1.) Download and install Teradata OLE DB driver on the target server where SQL Server 2000 is hosted. 2.) Right-click the Linked Server node under Security node in Enterprise Manager and select “New Linked Server...” 3.) On the General Tab:      -Choose a Linked Server name.      -Select “OLE DB Provider for Teradata“ from the “Provider Name“ Dropdown list under “Other data source“.      -Choose a name for the Linked Server in the “Product Name“ textbox.      -Enter the name of the Teradata database in the Product Name field.      -Enter a server domain name or IP address of the server that Teradata database is hosted on.      -Leave...

posted @ Tuesday, February 28, 2006 4:02 PM | Feedback (3) |

Powered by:
Powered By Subtext Powered By ASP.NET