var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DBCC SHRINKFILE fail
When i excute this command
DBCC SHRINKFILE(pubs_log, 2)
the message "Could not locate file 'TEST' in sysfiles.
DBCC execution completed. If DBCC printed error messages, contact your system administrator." raiseed.
please what is it?
thank a lot
Make sure you are running this command against the correct database in Query Analyser ( select the database at top of screen ). You cant run this command against Master database.
Last edited by sqlguy7777; 02-18-04 at 22:32.