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 |
|
santana
Yak Posting Veteran
72 Posts |
 Posted - 2009-10-15 : 03:00:21
|
| Hi,I working in one SQL Server 5 database, where I cant create tables, functions.... because it is a closed product (project).If I will create a new database, in the same Server, Can I see those tables and create process, tables....from those tables in this new environment (database)? Can I link those two databases (from the close product-project and from my new database)? How can I do this?Thanks!Regards, |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-15 : 03:48:18
|
| You can use DBname.ownername.objectnameMadhivananFailing to plan is Planning to fail |
 |
|
|
santana
Yak Posting Veteran
72 Posts |
Posted - 2009-10-27 : 10:25:09
|
| Ok.But how Can I read from the other database in the same server and input this data in other database in the same server?Are there anything like select * from tableA input select * from tableB? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-27 : 10:27:28
|
insert database2.dbo.tableBselect * from database1.dbo.tableA
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Link between databases