Posted - 01/07/2011 : 06:29:53
I had some sprocs on my DB set up to enable SQL Express (2008) backup scheduling as per:
I then ran a the following T-SQL to Grant execute permissions to all stored procedures in this DB:
GRANT EXECUTE TO New_DBS_user
Now 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