Access tables in a remote Database server
-
Hi, I am using MSSQL 2000 server. I need to access tables in the remote server from my local server query analyser. I know that server's name, its user name, password.... My need is from my local server query analyzer, i need to perform select or update or delete operation. is it posiible??
All I ever wanted is what others have....
CrazySanker -
Hi, I am using MSSQL 2000 server. I need to access tables in the remote server from my local server query analyser. I know that server's name, its user name, password.... My need is from my local server query analyzer, i need to perform select or update or delete operation. is it posiible??
All I ever wanted is what others have....
CrazySanker -
Thank you for your reply. My requirement is I have a User_log table in my Remote DBserver "RDB" and in my Local DBSERVER "LDB" .And databse name is TEST in both server. I need to insert (or copy) the content from
RDB.TEST.User_logtoLDB.TEST.User_log, after copying it i need to DELETE the contetnt ofRDB.TEST.User_logI need to perform this operation from my "LDB" can you help me??All I ever wanted is what others have....
CrazySanker -
Thank you for your reply. My requirement is I have a User_log table in my Remote DBserver "RDB" and in my Local DBSERVER "LDB" .And databse name is TEST in both server. I need to insert (or copy) the content from
RDB.TEST.User_logtoLDB.TEST.User_log, after copying it i need to DELETE the contetnt ofRDB.TEST.User_logI need to perform this operation from my "LDB" can you help me??All I ever wanted is what others have....
CrazySankerIf the databases are on different servers, you could define a linked server on one of your servers and then write an INSERT query that copies the data from one server to the other. I don't really have any experience of defining a linked server myself, but SQL BOL will explain how to do it. Alternatively, you could use DTS/SSIS to export data from one database and load it into your other database. Regards Paul