SQL Server Performance

Schedule Export Fails, Manual run okay

Discussion in 'SQL Server DTS-Related Questions' started by eklpublic, Oct 7, 2004.

  1. eklpublic Member

    Hi all,

    I get an error when I try to create a Schedule to Export data to an xls file. The error says ServerProperty is not a registered function name. I can run the export task repeatedly as long as I don't try to save it as a scheduled job.

    The user database roles for this login are public and datareader and public for msdb.

    Someone know what the problem is, a way around it?

    Thank you
  2. satya Moderator

Share This Page