One Paragraph of project description goes here
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.
| USE Exercises | |
| GO | |
| /* *********************************************************************************************** | |
| * | |
| * CRONTAB EXPANDER | |
| * | |
| * ***********************************************************************************************/ | |
| /************************************************************************************************** |
| --This query enables ole automation procedures. set 0 to disable | |
| exec master.dbo.sp_configure 'Ole Automation Procedures', 1 | |
| RECONFIGURE | |
| --OLE automation disabled the following error is thrown. | |
| --SQL Server blocked access to procedure 'sys.sp_OACreate' of component | |
| --'Ole Automation Procedures' because this component is turned off as part | |
| --of the security configuration for this server. | |
| --A system administrator can enable the use of 'Ole Automation Procedures' |