February 16, 2005 at 5:48 am
Due to Sorbanes Oxy (gov regulation) we had to lock down our servers which gave us developers not enough rights to carry out every day stuff. I need to have at leat execute rights(which I now do not have ) on the Master DB to send SQL mail with sp_send_cdosysmail, for use with Lotus Notes. Is there another way to acomplish (send mail) this without usng the master db's stored procedures? I still need to use Lotus Notes so Outlook would not be an option.
Thanks
Marty
February 17, 2005 at 2:59 am
sp_send_cdosysmail is not a standard SQL server object so it may be possible to have it in a user database. It depends what it calls in turn.
I take it the server in question is production.
So why, as a developer, are you connecting to a production server?
It may be the politics of your shop but the developers here (I'm the DBA) have no access to production servers except as end users. And shall only over my dead body and the corpses of my fellow DBAs. And our manager's body. And so on and so forth.
Can your task be scheduled within the SQL Server job system?
Do you have DBAs who can do it?
Why must developers do it?
February 17, 2005 at 12:26 pm
Well, I was trying to think of a possible workaround myself, but the prev. poster is really asking all the right questions here.
You really need to think about the answers to those Q's before going any further....
- j
February 18, 2005 at 1:45 pm
I found a workaround for my problem and it works great.
In case you needed answers to his questions:
Can your task be scheduled within the SQL Server job system? NO
Do you have DBAs who can do it? NO
Why must developers do it? We are the only ones who can.We have no DBA's
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply