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 - 2002-01-07 : 10:13:53
|
| Santi Das writes "I have a database in Microsoft SQL Server 2000 and I would like to pull data from some of the fields which exist in a table into another table which is in a second database in SQL Server. I would like to know how we could do it across two different databases. I can do that using triggers within the same databse but I just am not able to do it across two databases. Any help will be really appreciated!Thanks" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-01-07 : 10:18:31
|
| Your user will need permission on the other database.To access the tabledbname.owner.tblname.You can then use this just like a table in your current database.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Transeferring data from one database to another