dbcc shrinkdatabase

Hello
We use SqlServer 2000.

I'm trying to run the "dbcc shrinkdatabase" command on a specific database.
I keep on getting the message:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

I don't see any error messages but its obvious that the command never ran. There is no change in the size of any of the data base files. There are no messages in the event viewer or in the current activity log.

When I run the command on other databases it runs fine with all the output.

Any ideas ?

Thanks

David Greenberg
.

Relevant Pages

  • Re: DBCC error 913
    ... Then I run the command sp_dboption dbname,'Single user',true also. ... this command runs inside a cursor and DBCC checkdb commands starts after that. ... >> This is simple DBCC script I am running on the server every sunday. ... >> database is online and in live. ...
    (microsoft.public.sqlserver.server)
  • Re: How to deny DBCC SQLPERF(logspace)
    ... DBCC statements that act as Database Console Commands for Microsoft? ... I know that if we can find the place where the permissions of each DBCC ... command stored, we can update the table directly to change the permissions. ...
    (microsoft.public.sqlserver.security)
  • Re: Avoiding the use of CACHE in SQL2000
    ... I'll read each command. ... > DBCC FREEPROCCACHE clears the procedure cache and causes ad hoc queries to ... > if you want to clear the data cache you will need to use DBCC ... > specific database on a SQL Server, ...
    (microsoft.public.sqlserver.programming)
  • Re: Problems with Net::MySQL...
    ... mysql -u root -p ... into Perl -- the error messages from the command line are slightly less ... username is '' and your database is '!' ...
    (comp.lang.perl.misc)
  • Re: Shrinkfile does not find the file
    ... could you execute the below ... command to get the logical name for that database. ... After that use this logical name in DBCC SHRINKFILE command and try. ...
    (microsoft.public.sqlserver.server)