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 |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2005-02-23 : 19:59:27
|
| hi there,is it possible to execute a stored proc, in a database on another server from a trigger? e.g.I have 2 db servers in the same network. One with sql 7.0 the other with sql2000. the sql 7.0 db will have a trigger that needs to call a stored proc on the sql2000 server. how do I go about setting this up?thanks - matt |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-23 : 20:10:16
|
| You need to setup a linked server to the other server. Once created, you reference it by its 4 part naming convention:EXEC LinkedServerName.DBName.OwnerName.StoredProcNameTake a look in BOL for details about linked servers.Tara |
 |
|
|
|
|
|
access a stored proc in another db on another serv