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.
| Author |
Topic |
|
vidhya
Posting Yak Master
108 Posts |
 Posted - 2008-08-09 : 09:18:57
|
| Hi friends,I need query to transfer the table with data from one server to another server. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-08-09 : 11:32:29
|
| You can use import/export function in Management Studio.right click on database in the object explorer...WebfredToo Old to Rock 'n' Roll, Too Young to Die |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-09 : 11:38:16
|
| or use OPENROWSET. have a look at syntax in books online |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-10 : 14:19:37
|
| Or bcp |
|
|
|
vidhya
Posting Yak Master
108 Posts |
Posted - 2008-08-13 : 10:13:04
|
| i m in server 'system25' , database 'master' running the below code...SELECT *FROM OPENROWSET('MSDASQL', 'DRIVER={SQL Server};SERVER=system28;UID=sa;PWD=sa', acc.dbo.rpm_output) I m getting the error,OLE DB provider 'MSDASQL' reported an error. Authentication failed.[OLE/DB provider returned message: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.] |
|
|
|
|
|
|
Query to transfer the data from the server to anot