this is gotng to be a regular thing on daily basis.
i tried to link the server , but its not linking.
I tried to link server in Security ->Linked server in enterprise manager.
but its not working , means i can see the servers in the list but i cannot work.( i am lost)
please illustrate the steps and if possible the code used and where to write that code would be very greatful.
...
hatrick
Last Activity: Feb 12 '08, 06:19 PM
Joined: Feb 11 '08
Location:
-
I need to run query in DB3,
linking the two databases(in diff. servers) will only resolve the issue.
if i take another path like
copy the ID, nad other needed data in temporary table in DB2 and then selecting data from the two tables(which now be in same database) can be done .
but it involves copying huge amount of data in live server and then again selecting copying data to third server's database(which...Leave a comment:
-
have you tried the Import/ export wizard in the enterprise manager.??Leave a comment:
-
Linking two databases and copying details to third database
Hi ,
there is one table (T1) in database DB1, another table T2 in DB2 , i want to run a query which select data from these two tables and copy/ place this data into third table T3 in DB3.
All Databases are residing in different servers.
i tried sp_addlinkedser ver, but unable to solve the problem.
can anybody please tell me the steps to be follow to solve this problem.
No activity results to display
Leave a comment: