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 |
|
gary_gill
Starting Member
4 Posts |
 Posted - 2005-07-07 : 13:27:07
|
| i have a database(SQL SERVER) that i am accessing through IP address.i wantto copy table called custplus from that datbase to my local database calledLTEST and table name will be the samehow can i do thatguru vb.net |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-07 : 13:36:19
|
| Well you could setup a linked server so that you could do it via T-SQL. Once the linked server exists, then you just use the four part naming convention.Or you could just use the Import/Export wizard. Right click on the database in EM to check it out.Depends on your experience level which one you'll want to do.Tara |
 |
|
|
|
|
|
sql server query or stored procedure