Hi,
Have a look in the SQL Server Admin for blocked tasks,you may been running into a file/record lock etc. In this case you will have to change code to over come the problem.


>Hi,
>
>My client windows 2003 server have the follow configuration
>01) 4 intel 3.4GHz intel processor
>02) 3.5G of RAM
>03) 72G of SCSI hardisk
>
>Our ASP.NET written application will access the above sql server
>for data.
>
>However, when the memory usage of the SQL server hit 1.2G in the
>task manager. All our application and C# written migration application will halt or hang.
>
>We are confused why this happen.
>
>Anyone with similar problem can advise me or
>assist me on why our ASP.NET or C# application halt or hang.