When i start a maintenanceplan if it's scheduled or not i want to be able to see the ETA of the plan.

Hi Adam,

maybe these links will help you on the way:

http://msdn.microsoft.com/en-us/library/ms190488.aspx

http://msdn.microsoft.com/en-us/library/ms189493.aspx

Bryan

Hi Guys,

Thanks for mentioning this option from microsoft. This was what i was looking for. And you're right

about reinventing the wheel.

Bryan

thanks for the suggestion.

Of course here it is:

use master

grant execute on xp_prop_oledb_provider to [USERNAME]

Hi,

solved the problem by just giving the user the right to a system view.

bryan

Hi Paul,

thanks i'll just try that.

Bryan

Not by clicking here and there, but with a function probably?

Hi,

Isn't there a way to do this directly in the database?

bryan

thanks again.

bryan

Hi pradeep,

another question. is there a way to suggest a user has db-owner rights, to make a trigger which prevents the user from doing a backup/restore or drop from de...

Hi Pradeep,

thanks for your answer. i will do that for sure.

kind regards,

bryan

Hi Pradeep,

the user has db_owner rights. isn't there a way besides taking away db-owner rights to prevent the user from making backups.

bryan

Hi,

Thanks a lot for the info. You know when we started to use this product (veritas) for clustering this is how it was installed with our partner using their best...

Hi,

Thanks for the information. I've now seen what my problem is. We work with a veritas clustered environment on windows. So we configured each instance as an virtual machine with...