Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 query to copy and work on data in diff server

Author  Topic 

scottichrosaviakosmos
Yak Posting Veteran

66 Posts

Posted - 2010-07-26 : 02:13:53
i want to copy data from one database to another on different machine or server.
and i also want to perform differnt query operation on that other server database and its tables.
i know tat there is something called link server but i dont know to configure it and wt to do in that.
can someone tell me steps for all this i m new to this.

scoo

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2010-07-26 : 02:23:18
Refer this..

http://blogs.techrepublic.com.com/datacenter/?p=133

http://msdn.microsoft.com/en-us/library/aa560998(BTS.20).aspx

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/
Go to Top of Page
   

- Advertisement -