>Hello,
>
>I ran it using both interactively and by command: DBCC (mydatabase,25) .. never ending process (now I am waiting this process for almost 1 hours) .. is it bugs or what? .. btw, my sql server 2005 is already SP3..
>
>please help
>
>Thanks & Regards
>Winanjaya
Just an idea - perhaps it would help to do this operation in single user mode
http://msdn.microsoft.com/en-us/library/ms188236.aspx
If it's not broken, fix it until it is.
My Blog