Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-19 : 09:38:46
|
| Gary writes "I have a SQL database that contains a table which has records inserted and deleted as members enter and leave a club.These records are replicated from this table to an access table on numerous tills.The problem is that this table keeps on getting larger and larger.At the end of the day there is no records left in this table, but it is still large i.e at the moment it is 1.6GBI have tried al sorts to make it smaller. The only thing that has worked is Truncate Table but this means removing all the replication and then adding it all again.Do you have any suggestions as to how I can clear it down without removing replication.ThanksGary" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-02-19 : 09:56:48
|
| Try using DBCC CHECKTABLEDBCC SHOWCONTIGDBCC SHRINKDATABASEcheck BOL for furthur info on them.-------------------------------------------------------------- |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-19 : 10:02:24
|
| Is it the Access file that is getting big? If so, then use the Compact Database option on the Tools:Database Utilities menu. |
|
|
|
|
|
|
Large table in SQL