There is nothing like a ZAP in SQL Server. The engine manages it by itself.
The only thing is that you can schedule maintenance job to shrink the database.
>Hi,
> I have an excel file that I need to import to my SQL server once in a while (on a fixed basis,like once a week). The excel file itself is update whenver needed, and everytime we updated, we simply need to wipe out the whole SQL table and replace it with the current Excel table.
>Is there a way to creat a "routine" that runs automatically on a regular basis that wipe out data from the table (ZAPing it in Foxpro term) and import the excel file into the SQL server.
> I am not familiar with stored procedure though.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com