Search results for query: *

I have been a SQL DBA for about 10 years so I'm ok with querrying the database. We have recently converted our Access IMA to SQL and now the databases sit on my server. Recently my boss asked me to see whether I can extract any usefull info out of there. The only thing I have been able to get is...

Select querries will not mess up anything.

I have just recently started looking at the ima databases in our SQL Server. We have an IMA and an RMS database. Does anyone have some querries to share to extract useful information?

We have new development in this issue. We have converted the field Date_closed to char and then back to date format. Now the engine DOES NOT CRASH anymore. The trouble is that along with the null fields also about 10 records with date values in the date_closed are also included in the result...

Hello. MrBucket here. I have tried running consistency check and most of the tables have failed it, citing either invalid columns or missing files. I also tried rebuilding the table in question today. I have been able to rebuild it but upon testing the query again I crashed the system. I am...

The files in question have the same dates: W3ODBCEI.DLL is 02/20/2003 W3ODBCCI.DLL is 02/20/2003 W3DBSMGR.EXE is 02/20/2003

How can I tell what version I am on and what service pack or patch I am on?

Thank You for your response. We are on 8.0. The two services I see are Pervasive.SQl(relational) and Pervasive.SQL(transactional). How do I check into turning off the cache?

We have recently upgraded our database from btrieve to PervasiveSQL. We started having connectivity issues. Upon inspection of the server I noticed that the CPU is pegged at 100% all the time. At the time of this writing it has been over an hour and the CPU is still at 100%. There are...