>Can I recover deleted records?,
No.
>Is there any compacting method for SQL Database?
Because deleted records are not recoverable, there is no need to compact (everything is done automatically).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
