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 |
|
petebob796
Starting Member
35 Posts |
 Posted - 2008-02-09 : 15:50:52
|
| I am using two databases on the same ms sql 2000 server one is called standard and one is called RDC. This is an upscaling project from ms access I would prefer to keep the two seperate as standard is used by many things and RDC is more standalone. In some of the stored procedures and views in RDC I need to access the tables in standard. I assume this is possible but don't know the syntax. Basically I want to do an inner join onto a table in standard. |
|
|
petebob796
Starting Member
35 Posts |
Posted - 2008-02-09 : 16:01:18
|
| It's ok I have resolved it now for some reason the first time I prefixed the table with the database name it didn't work but it is now |
 |
|
|
|
|
|
Use table from different database same sql server