Hi,
I have a stored procedure which is quite big.When i run stored procedure on Windows Azure Sql Database, it running and got hang on a particular point of time.
After that it never showing completion status for the running stored procedure.
Sometime it inserted/updated/deleted all requested data but still showing running/ hang.
How i overcome this hanging problem/ or is there any alternate way to know that query execution completed but it showing hang ?
Please provide some suggestions/options with Windows Azure Sql Database.
Thanks!!