Click here to Skip to main content
15,883,901 members

Comments by ashu2001 (Top 5 by date)

ashu2001 15-Jan-19 0:53am View    
Hi although this is a quite old post but i am struck with the same problem as well changed the PORT from 25 to 50 but no luck. In my case my mail takes ages to shoot and it slows down the post back event as well which in turns ruins the performance as well. I tried to use threading concept as well but no luck in that case as well. In my case while debugging every thing goes fine and mail is sent within a second. Can any help to find out the exact problem
ashu2001 2-Aug-13 0:35am View    
When i se ARITHABORT OFF in the procedure it gives me

"DELETE failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods."

i got the above error at below location

DELETE FROM ABC Table(A physical table with calculated Field with Persistance)
WHERE ( Host = HOST_NAME()
OR Host = ''
)
ashu2001 2-Aug-13 0:31am View    
@Raja. I am getting "Warning: Null value is eliminated by an aggregate or other SET operation" but not able to identify at which location i am getting this warning, wat i think i that i am getting this warrning when i try to Insert/update any selective information in the computed table.
ashu2001 1-Aug-13 7:27am View    
will using Non Persisted Computed column save me from this problem???
ashu2001 26-Oct-12 4:38am View    
Can u share any great idea of server side pagination...it will help alot