| Author |
 Topic  |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 15 December 2004 : 18:34:04
|
You just need to fully qualify the stored procedure name: Database1.owner.sp1
Tipically owner is dbo and that being the case it would be: database1.dbo.sp1
Other than this there is no difference to execute a local stored proc. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 16 December 2004 : 05:26:26
|
| Just a fyi - UDF's (User-defined-functions) can be used similarly, and can do some stuff you just can't do nicely with a sproc - for instance a recordset-returning sproc cannot be treated as a tabel in another sproc, but a table-returning UDF can. Sweet :) |
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
Posted - 16 December 2004 : 07:15:33
|
quote:
Originally posted by ruirib
You just need to fully qualify the stored procedure name: Database1.owner.sp1
Tipically owner is dbo and that being the case it would be: database1.dbo.sp1
Other than this there is no difference to execute a local stored proc.
Nice! I had been wondering about that one for a while now.  |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
|
|
| |
Topic |
|
Topic Locked
