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 |
|
kingroon
Starting Member
29 Posts |
 Posted - 2007-04-30 : 01:44:37
|
G'day..I have a Stored Proc that extracts numerical data for an XML feed e.g. spXMLFeedData. The SP also monitors this data, checking for any NULL or 0.00 values before the RS is returned, sending an email to myself should there be a flaw in the data.. Problem is, the email SP e.g. spMailQueueAdd, sits on another catalog.Is there a way of executing the email SP if the user executing the spXMLFeedData does not have permissions on that catalog? So instead of the use command, is there a way of logging onto the other catalog within the spXMLFeedData?   Cheers..MattDogFightClothing. No dogs. No fighting.http://www.dogfightclothing.com |
|
|
mattyblah
Starting Member
49 Posts |
Posted - 2007-04-30 : 12:06:48
|
| why not [catalog].dbo.stored_proc_name to call the stored proc? You still won't be able to run it though if the user doesn't have permission... |
 |
|
|
kingroon
Starting Member
29 Posts |
Posted - 2007-04-30 : 18:14:49
|
Hi mattyblah..Cheers for the reply. You highlighted the problem I'm already having unfortunately.. "..Is there a way of executing the email SP if the user executing the spXMLFeedData does not have permissions on that catalog.."DogFightClothing. No dogs. No fighting.http://www.dogfightclothing.com |
|
|
|
|
|
|
Changing catalogs within a SP