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 - 2004-04-02 : 08:54:20
|
| Naser writes "In a store procedure called A there is a command as follow:Exec DataBase1..B @C OUTPUT@C , has defined in A and B store procedureA is in DataBase2How can I , pass DataBase1 as a parameter to A?Set A,B is in One Server...Thank you for responsing.... Nasser Rezaei." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-02 : 12:22:26
|
| Could you explain further? I don't understand your question. It sounds like you are going to need dynamic sql, but one should look at redesigning your system first.Tara |
 |
|
|
|
|
|
pass database name to a exec command