March 22, 2002 at 5:05 am
Have to run DBCC CHECKDB to see if anything is found wrong with the database itself? Or DBCC CHECKTABLE? Could be a problem with the allocations for the table internal to the database.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 24, 2002 at 6:20 pm
Yes, I have already run DBCC and have checked everything I can think of.
March 24, 2002 at 7:58 pm
Are you using text columns in the affected tables? Local query or distributed?
Andy
March 24, 2002 at 11:06 pm
quote:
Are you using text columns in the affected tables? Local query or distributed?Andy
The tables are accessed as linked tables through Access 97. One table has 4 text fields and the other has 3. We are using alot of text fields in the database.
When you say Local query or Distributed? Do you mean how are the tables being accessed? I can find no correlation between user activity and the crashes. The only connection to the tables is when people login using the Access front ends they attach to a number of linked tables (around 80) including the 2 which show up in the Log and specifically the one causing the ShutDown. But there is no activity on the tables when it crashes.
March 25, 2002 at 5:19 am
Distributed meaning use a linked server or openrowset. Do you have the text colummns full text indexed?
Andy
March 25, 2002 at 5:42 am
I think Andy is referring to the following KB Article on Microsofts site.
Which you state you have SP3 and this should have fixed. You could have had issues though with the SP3 install that did not show up and may want to reinstall.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 25, 2002 at 6:55 pm
I am not using any Text indexes, just the Primary Key (integer) in both tables, but that Fix Q277839 sounds very much like what I am experiencing.
I think I will reinstall the SP3 to see if that helps. As I haven't tried that yet. We are migrating to SQL Server 2000 as soon as our W2K Server is operational and I am suspecting that the problem will go away once we move, but that could be a while.
April 1, 2002 at 6:24 am
Let us know if SP3 reinstall helps.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 15, 2002 at 10:30 pm
I haven't reinstalled SP3 but I have managed to track down what was causing it. I had a View which was based on a Union of a few tables which contained Text fields. I had to cast the text fields as varchar(255) before they were Unioned. The database only had a problem with it when the View was accessed as a Linked Table in Access97. This problem did not happen under SQL Server 2000. Thanks for the suggestions.
Viewing 9 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply