I would like to give the db_creator server-role to a specific SP which can be used to create/refresh database snapshots. I do not want to grant the role to the login. Any ideas, or information how this can be done?
You can't make a stored procedure a member of a role and only logins can be members of a server role. You might look at EXECUTE AS in Books Online to see if that would be an option for you.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply