select name,recovery_model_desc from sys.databases GO Alter database YourDatabaseName Recovery simple GO Declare @LogFileLogicalName sysname select @LogFileLogicalName=Name from sys.database_files where Type=1 print @LogFileLogicalName DBCC Shrinkfile(@LogFileLogicalName,100)
- Kirby Turner
Mobilefish.com - A tutorial about CVSNT, a concurrent versions system. Installing CVSNT 2.5.03. Includes examples. - http://www.mobilefish.com/develop...