配置sqlserver自定义函数.txt 534 B

1234567891011121314151617181920212223242526272829303132
  1. --开启 Ole Automation Procedures
  2. sp_configure 'show advanced options', 1;
  3. GO
  4. RECONFIGURE;
  5. GO
  6. sp_configure 'Ole Automation Procedures', 1;
  7. GO
  8. RECONFIGURE;
  9. GO
  10. EXEC sp_configure 'Ole Automation Procedures';
  11. GO
  12. --关闭 Ole Automation Procedures
  13. sp_configure 'show advanced options', 1;
  14. GO
  15. RECONFIGURE;
  16. GO
  17. sp_configure 'Ole Automation Procedures', 1;
  18. GO
  19. RECONFIGURE;
  20. GO
  21. EXEC sp_configure 'Ole Automation Procedures';
  22. GO
  23. --关闭高级选项
  24. sp_configure 'show advanced options', 0;
  25. GO
  26. RECONFIGURE;
  27. GO