Shulou(Shulou.com)05/31 Report--

SQL Server how to regularly access url to activate data synchronization, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Create a job, execute the following command exec master..XP_cmdshell 'http://srm.rapoo.cn?op=sapintferace&i=1&t=1' activate to execute synchronous network steps the following content comes from the network, describes how to enable the xp_cmdshell extended stored procedure to command I. the xp_cmdshell extended stored procedure executes the command string as an operating system command shell and returns all output in the form of text lines. Third, xp_cmdshell in SQL Server 2005 has security risks, so in SQL Server 2005, xp_cmdshell is off by default. At this point, if the xp_cmdshell is executed, the service will be prompted that the service is not turned on: message 15281, level 16, status 1, procedure xp_cmdshell, line 1 SQL Server blocks access to the component 'procedure of xp_cmdshell'' sys.xp_cmdshell' because this component has been shut down as part of the security configuration of this server. The system administrator can enable 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Peripheral Application Configurator" in SQL Server Books online. Open xp_cmdshell EXEC sp_configure 'show advanced options', 1 position exec sp_configure' xp_cmdshell', 1 position; close the same. Just change the "1" at the back above to "0". EXEC sp_configure 'show advanced options', 1: reconfigure exec sp_configure' xp_cmdshell', 0; failed to find stored procedure 'RECONFIGURE

Step 1: EXEC sp_addextendedproc xp_cmdshell,@dllname = 'xplog70.dll'declare @ o int

Step 2: sp_addextendedproc 'xp_cmdshell','xpsql70.dll'

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.