Stored Procedure ado.net recursive Binary Tree /////////////////////////////////// //////////// the BCP database name in the sql2005 environment cmd-> BCP. DBO. table name out E: \ 2.txt-c-k-s "server address/IP"-U "SQL account"-P "SQL password" is imported successfully. Select top 0 * into database name. DBO. table name from Highway Bridge. DBO. bridgeinfo successful gobcp Highway Bridge. DBO. bridgeinfo in E: \ 1 \ bridgeinfo.txt-C-s "ditto"-U "ditto"-P "ditto" failed // start to report this error. SQL Server blocks the 'xp _ javasshell' process 'sys. for access to xp_cmdshell, the solution is as follows: queryer-> exec sp_configure 'show advanced options', 1; reconfigure; Exec sp_configure 'xp _ cmdshell', 1; reconfigure reference: dizzy or error, but another error: 1. sqlstate = hy000, nativeerror = 02. error = [Microsoft] [SQL native client] cannot open the BCP master data file. 3. nullgoogle cmd-> netsh interface IP reset C: \ log.txt reset log.txt // reset TCP/IP and related components to a clean state; otherwise, the network will not be able to run cmd-> BCP Highway Bridge in DOS. DBO. bridgeinfo in E: \ 1 \ bridgeinfo.txt-C-s "Same as"-U "Same as"-P "Same as" Success ////////////////// /// // msdn for xp_cmdshell: http://msdn.microsoft.com/en-us/library/ms175046 (V = SQL .90 ). aspx reference: expose to prevent SQL port viruses. Refer to the above website to use masterexec sp_dropextendedproc 'xp _ javasshell' go to restore mongoshell. The SQL syntax is exec sp_addextendedproc xp_mongoshell, @ dllname = 'loglog70. dll '////////////////////////////////////// ///