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...