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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2004-08-16 : 12:47:35
|
| How can i call a stored procedure of a different database Say Iam using a query in Database A and I want to use a stored procedure used in a database B both are in the same server will B.dbo.storedprocedurename will work |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-16 : 12:48:45
|
| yesEXEC B.dbo.storedprocedurenameMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-16 : 12:48:48
|
| Yes you just use the 3 part naming convention to get to the remote object.Tara |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-08-16 : 12:50:46
|
| yes. but why don't you try and see for yourself?Go with the flow & have fun! Else fight the flow :) |
|
|
|
|
|
|
stored procedure call