I have 1 table in a 200+ table database
The database is Merge Synchornised and has been working fine for 2
years +
The same database is at several customers and the DB is fully
relational
I have a table which creates client timeout errors whenever an insert
or update is issued
The table has foreign keys and primary key and links parent to
children tables so if I need to recreate the table I will also need
advice on the best way to do this to keep the integrity of the
database
I wasn't sure the table was the problem so I deleted all publications
and disbled the server from being a distributor
I cannot find any error logs with any clues so can only assume the is
the first corruption I have ever seen on SQL 2K (SP3)
I have defragmented the drive, reindexed the tables, shrunk databases
(Plenty of space available)
Please advise any course of action you think may help me.
Regards Paul Goldney