"Transport-level Error" using SQL Server Stored Procedure and Cursor -


i have created stored procedure auto follow users , procedure on server. in database, there 20,000+ users. store procedure uses cursor.

i getting error a transport-level error has occurred when receiving results server. (provider: tcp provider, error: 0 - existing connection forcibly closed remote host.)"

this stored procedure . 

                declare @useridf int             declare @userid int          declare csrautofollow cursor         select  top (1) userid dbo.users  isfuser = 1  order newid()          open csrautofollow             fetch next csrautofollow @useridf              while @@fetch_status = 0             begin                             declare csrauto cursor                             select userid dbo.users isfuser null                               open csrauto                                 fetch next csrauto @userid                              while @@fetch_status = 0                                begin                                         exec dbo.followunfollowuser @useridf,@userid,1                              fetch next csrauto @userid                                end                                 close csrauto                                deallocate csrauto                  fetch next csrautofollow @useridf                end                  close csrautofollow        deallocate csrautofollow

please let me know whether can improved.

"transport level error" means computer stored procedure called has lost network connectivity database server stored procedure lives on. has nothing code of procedure.

you need have network admin problem.


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more