Hi,

What does this script do?

grant execute on xp_prop_oledb_provider to [User_ID]

I'm currently encountering this error and nto quite sure if this is the only to resolve this error: "Execute permission denied...

Hi Bryan and Manu,

I would like to know what will be the effect in granting execute permission to xp_prop_oledb_provider to a user in the database.

Currently, I'm encountering an issue...

I also needed to know what "xp_prop_oledb_provider" is all about? Can anyone help?

Are we granting another access to the user when we grant them additional execute permission in this...

Hi,

See syntax below:

Use master

Backup database [database_Name]

to disk = 'path_of_backup_file'

with

init,

copy_only,

stats = 10

Hope this helps!