Viewing 3 posts - 1 through 3 (of 3 total)
SQL Server 7
DataBase : DB1
Table : TB1
command :
use DB1
dbcc shrinkfile(TB1,7)
but I had response msg :
Server: Msg 8985, Level 16, State 1, Line 1
Could not locate file 'TB1' in sysfiles.
DBCC execution...
July 1, 2008 at 10:01 pm
#836982
how to make empty transaction log sql server 7
July 1, 2008 at 8:15 pm
#836970
Mr. Gail Shaw
How to clear out space ?
thanks
July 1, 2008 at 2:42 am
#836510