Access Front-end & SQL Server Back-end

[worksfire1]

It's been a long time since I dabbled in SQL Server. It was back in the day
on SQL 6.0! Due to load needs, the Sr. Analyst in my department (IS) had to
switch from an Access Back-end (BE) to SQL Server BE on a database. I know
when she had a corrupt record issue in Access every once in a while, we can
do a "Compact & Repair" and fix the record and then everything works again.
Does anyone know off hand what the SQL Server equivalent to a "Compact &
Repair" is? If there is a better forum, I apologize and would love a link to
it. But if anyone knows the answer, that is a PLUS, too!

 

[Rick Brandt]

It's been a long time since I dabbled in SQL Server. It was back in
the day on SQL 6.0! Due to load needs, the Sr. Analyst in my
department (IS) had to switch from an Access Back-end (BE) to SQL
Server BE on a database. I know when she had a corrupt record issue
in Access every once in a while, we can do a "Compact & Repair" and
fix the record and then everything works again. Does anyone know off
hand what the SQL Server equivalent to a "Compact & Repair" is? If
there is a better forum, I apologize and would love a link to it.
But if anyone knows the answer, that is a PLUS, too!

SQL Server has no need for this in the same sense, but there is a "shrink
database" command that is as similar as you are going to get. It can even be
set to do this automatically on a continuous basis.