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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-03 : 07:49:30
|
| Georgia writes "hi,can anybody tell me how to copy and paste specific tables and stored procedures from one database (my sql server 2000) in one pc to another database (also my sql server 2000) in a remote pc? Is there anyway to take them in a floppy disk? When i use import-export through MS Access I loose data! thanks in advance,georgia" |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-11-03 : 07:49:40
|
quote:
Originally posted by AskSQLTeam
Georgia writes "hi,can anybody tell me how to copy and paste specific tables and stored procedures from one database (my sql server 2000) in one pc to another database (also my sql server 2000) in a remote pc? Is there anyway to take them in a floppy disk? When i use import-export through MS Access I loose data! thanks in advance,georgia"
you can export the objects in question by using Enterprise manager...He is a fool for five minutes who asks , but who does not ask remains a fool for life!http://www.sqldude.4t.comhttp://www.sqljunkies.com/weblog/sqldude |
 |
|
|
|
|
|
synchronizing two databases so as to be identical