fwsteal
asked on
truncate database in 2005
what is the new way to do this in sql 2005?
select * from sysfiles backup log DBName with truncate_only DBCC SHRINKFILE (2,0)
select * from sysfiles backup log DBName with truncate_only DBCC SHRINKFILE (2,0)
This should work on SQL 2005
ASKER
it works but I get warnings that it is depreciated.
Strange, I get no such warning. What statement exactly generates it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I get the depreciation during the execution of a SSIS package.