If you want to shrink your log down to 1k, you need to use something like this
George Esser
CREATE PROCEDURE TruncateExportLog
AS
SET NOCOUNT ON
DBCC SHRINKFILE (ExportDoc_Log, TRUNCATEONLY )
BACKUP LOG ExportDoc WITH TRUNCATE_ONLY
if exists (select * from dbo.sysobjects where...
Hi I am using a SQL statement in Microsoft Query Analyzer
It is retrieving data from a dBase III File.
SELECT *
FROM OPENROWSET ('MSDASQL','Driver=Microsoft Visual FoxPro Driver;
SourceDB=\\max\C\D\BetterBeef\DBF\...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.