Have a storeprocedure in SQLserver that creates Excel file from Database table has 96312 records when triggered from Sqlserver no issues. it creates an excel xlsx file when i call the store procedure from my web code as
query="exce sp_Conversionbackup";
comm=new SqlCommand(query,Conn);
conn.Open;
comm.ExecuteNonQuery();
The get created but with only 48400 records . repeatedly is there some timeout working here i did try to add
connect Timeout=600 in my SQLconnection but that did not change anything
Go to the complete details ...