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 |
|
vishal_7
Posting Yak Master
127 Posts |
 Posted - 2005-11-22 : 13:02:44
|
| Hi, I am using asp.net which connects to SQL with the srvusr. The sp inserts a new row into the table. The table has a trigger which executes 'sp_makewebtask' and adds the first row into a file. However I am getting the error message:Only members of the sysadmin role can execute this stored procedure. The sp runs, its the trigger that fails. I tested it. Now how can I run the 'sp_makewebtask' without adding the user into the admin role? Basically all I need is that the trigger modifies a file. I dont care which sp is used. It just needs to modify the file.Thanks |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2005-11-22 : 13:18:15
|
| Copied from sp_makewebtask-- Make sure that it's the SA executing this. IF ( NOT ( is_srvrolemember('sysadmin') = 1 ) ) BEGIN RAISERROR( 15003, -1, -1, 'sysadmin' ) RETURN(1) ENDSo you cant"God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
 |
|
|
vishal_7
Posting Yak Master
127 Posts |
Posted - 2005-11-22 : 13:18:53
|
| Is there any other way? |
|
|
|
vishal_7
Posting Yak Master
127 Posts |
Posted - 2005-11-22 : 15:15:56
|
| Can someone help me? I just need to modify the file. |
|
|
|
|
|
|
sp_makewebtask