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 |
|
anita.86
Starting Member
21 Posts |
 Posted - 2012-01-03 : 02:24:07
|
| Hello, i have 2 d/b 1)college_dataentry 2)collegedatabasein college college_dataentry some records is very imaportant so i want to show on application (website).. in connection string collegedatabaseavailable, should i connect 2 database in same application?reply fast plzN/A |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-03 : 06:29:46
|
| thats only way. another way is to connect to one of db and run a distributed query which connect to other db from it, though it might be a lot slower depending on amount of date retrieved, complexity of operatons etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-01-03 : 07:36:25
|
quote:
Originally posted by anita.86
....reply fast plzN/A
Hey Visakh your reply is late by exactly 4 hrs 5 mins and 39 secs if I have done my maths right  Next time make sure you reply fast....After Monday and Tuesday even the calendar says W T F .... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-03 : 09:38:47
|
quote:
Originally posted by Sachin.Nand
quote:
Originally posted by anita.86
....reply fast plzN/A
Hey Visakh your reply is late by exactly 4 hrs 5 mins and 39 secs if I have done my maths right Next time make sure you reply fast....After Monday and Tuesday even the calendar says W T F ....
I never realised I'm getting paid for my posts  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Fetching from 2 database on 1 application