Posted by Erland Sommarskog on 08/21/06 22:04

PFI (patrick.fiche@aqsacom.com) writes:
> I recently installed SQL Server 2005 Enterprise Edition (9.0.1399) and

First of all, that's the RTM version. I recommend that you download
and install SP1. http://www.microsoft.com/sql/sp1.mspx

> I have problems on queries concerning system file manipulation...
> For example, when I try to increase the Log File of MSDB database :
> ALTER DATABASE msdb
> MODIFY FILE
> (NAME = 'MSDBLog',
> SIZE = 50MB)
>
> This query never terminates...
>
> All SQL queries for database creation never terminate

Compress drive? Network share? Have you tried to reboot the server?
Have you checked in task manager if there is any CPU? Or any other tools
to check for activity?

Sorry, not much of answer, but it's difficult to diagnose a system without
access to it.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]