Viewing 2 posts - 1 through 3 (of 3 total)
Yeah, linked servers require elevated permissions, it's one of their drawbacks. For data of significant size, ddl_admin is pretty much required on the remote side or your plans could suffer:...
December 10, 2014 at 8:54 am
#1763819
I know this is delayed, but I just tangentially heard about this problem.
I bet it's permissions.
From MSDN:
http://msdn.microsoft.com/en-us/library/ms187354.aspx
"Only members of sysadmin can modify a schedule owned by another user."
December 9, 2014 at 2:57 pm
#1763666