dbcc loginfo('DBNAME')
use DBNAME
declare @LogFileLogicalName sysname
select @LogFileLogicalName=Name FROM sys.database_files where type=1
print @LogFileLogicalName
DBCC SHRINKFILE (@LogFileLogicalName, 1)
DBCC SHRINKDATABASE(DBNAME)
dbcc loginfo('DBNAME')
use DBNAME
declare @LogFileLogicalName sysname
select @LogFileLogicalName=Name FROM sys.database_files where type=1
print @LogFileLogicalName
DBCC SHRINKFILE (@LogFileLogicalName, 1)
DBCC SHRINKDATABASE(DBNAME)