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 |
|
Lorna70
Starting Member
19 Posts |
 Posted - 2011-01-07 : 06:29:53
|
| HiI had some sprocs on my DB set up to enable SQL Express (2008) backup scheduling as per:http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-expressI then ran a the following T-SQL to Grant execute permissions to all stored procedures in this DB:USE DBS_NewGRANT EXECUTE TO New_DBS_userNow the scheduling as stopped working so I can only assume it's a permissions problem as it it was working fine before I ran this T-SQL. What do I have to do now to get them to run again?? I'm not sure which user they were running under before - how do I find this out?Lorna, Web developer, Scotland |
|
|
|
|
|
Sprocs permissions - how do I check??