|
Lorna70
Starting Member
United Kingdom
19 Posts |
 Posted - 01/07/2011 : 06:29:53
|
Hi
I 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-express
I then ran a the following T-SQL to Grant execute permissions to all stored procedures in this DB:
USE DBS_New
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 |
|
Sprocs permissions - how do I check??
