Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Location
    Korea
    Posts
    9

    Unanswered: How to make JOB without xp_regread procedure

    Hi!!

    I removed 'xp_regread' procedure for security

    after that I can't make JOB in Enterprise Manager

    How can I make JOB without 'xp_regread' procedure

    thanks~

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Do not remove extended stored procedures without first checking dependencies and fully researching their functionality. Add it back and just remove the execute permission from public.
    If you do not have SQL Server Books Online (BOL) installed - please do so. The majority of questions asked in the SQL Server forum could be eliminated if people had access to bol. BOL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •