Please give me an advive
-
I have an application using SQL Server database. After a few insert new data from application into database. That database is seem to be stucked. I can query any function from it any more. I must wait for a while, stop and then restart SQL Server, close (if it's opening) and then open Query Analyzer and change the database processing to the database that my application works with in order to make it works again . And i must exactly follow all the steps above to make it works again. If i try inserting data from Query Analyzer, there's no thing wrong appears. but right after that if i try to delete that database, i will receive a message that i can't delete that database because it's in use (although i closed my app and query analyzer already). I (again) must stop, and restart SQL Server to delete. What's my problem? The error is caused by my app or my SQL Server? Please help me. Thanks!
-
I have an application using SQL Server database. After a few insert new data from application into database. That database is seem to be stucked. I can query any function from it any more. I must wait for a while, stop and then restart SQL Server, close (if it's opening) and then open Query Analyzer and change the database processing to the database that my application works with in order to make it works again . And i must exactly follow all the steps above to make it works again. If i try inserting data from Query Analyzer, there's no thing wrong appears. but right after that if i try to delete that database, i will receive a message that i can't delete that database because it's in use (although i closed my app and query analyzer already). I (again) must stop, and restart SQL Server to delete. What's my problem? The error is caused by my app or my SQL Server? Please help me. Thanks!
I'd check for open transactions..that aren't being committed/rolled back etc..