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 - 2010-01-12 : 05:24:57
|
| Hi,I working with SQL Server 2005 database, where I cant create tables, functions.... because it is a closed product (project).If I will create a new database, in other 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 for diferente server)? How can I do this?Thanks!Regards, |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2010-01-12 : 05:30:12
|
| you'll have ot create linked servers between the two servers. look up the examples in SQL Server Books Online Help___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.7 out! |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-12 : 05:42:38
|
| seehttp://msdn.microsoft.com/en-us/library/aa560998(BTS.20).aspxhttp://msdn.microsoft.com/en-us/library/aa213778(SQL.80).aspx |
|
|
|
santana
Yak Posting Veteran
72 Posts |
Posted - 2010-01-12 : 06:26:41
|
| Hi,thanks for all replay.I am looking that!Regards, santana |
|
|
|
|
|
|
Link between two server