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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2004-07-09 : 12:45:22
|
| I have a SP in the location DB in server A. Looks like:Create proc splocation @start_date datetime, @end_date datetimeASSelect * fromloc where location_careate_dt between @start_date and @end_dateI would like to create another SP located in the location DB in server B( linked server) witch will call a splocation SP in Server A. Something like:Create proc call_location @start_date datetime , @end_date datetimeAsExec A.location.dbo.splocation ‘@start_date’, ‘@end_date’How do I make this works? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-09 : 12:59:31
|
| So it isn't working? You just need to use the 4 part naming convention for the remote stored procedure. What error are you getting? Did you setup a linked server on ServerB that points to ServerA? You might need to create an alias to support the linked server, but perhaps not.You shouldn't have single quotes around the variables in the second sproc.Tara |
 |
|
|
|
|
|
Calling a SP from another SP in the linked server