I got a big sp that i have to run that take up to hours. I need is to find a way to run a sp beside doing
and it times out and crashes the web site. It looks like it does go on running the sp but im not really sure if its right. or not
Dim cmd As New OleDbCommand
Dim Dr As OleDbDataReader
Dim Conn As OleDbConnection
sSQL = "exec Import_Process_DataEntry_RO " & Session("opid")
cmd = New OleDb.OleDbCommand(sSQL, Conn)
I can build my own tracking mechanizm just using track tables and stuff but i do need it to run by it self. so the page wont time out. Is this possible thank you.