Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have developed a simple App in Microsoft VB.Net 2008 in which I have implemented database connectivity with SQL Server 2000.

After 4 to 5 executions of the program I often find my database goes suspect.

Can anyone give me any suggestion why this would happen?

share|improve this question

closed as too localized by jcolebrand Sep 12 '12 at 19:28

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

You need to provide a lot more information to get an adequate answer. Is the SQL Server instance on your local machine or a dedicated server? What's your app doing? Why are you using SQL Server 2000? – JNK Aug 10 '12 at 12:14
I 'm using this software on my local machine as this is giving such problem i'm not taking any risk to run it on dedicated server at my office, i am using sql server 2000 because i have developed this software to be used at my office at there sql server 2000 is installed. The application performs simple database connectivity operations – Bhavesh Raval Aug 10 '12 at 12:27
What is the error message you get? Please edit the question with more details (and why is it tagged SQL 2008?). – Jon Seigel Aug 10 '12 at 12:49
Fire the command : DBCC CHECKDB – JP Chauhan Aug 10 '12 at 13:00