Thanks for the link, I'll have a look.

Now that I have got this to work, I can get down to the business of automating some of the tasks I have...

I got the script to work by launching powershell from Start --> Run and typing powershell, clicking OK.

However, when I launch powershell from SQL Server Management Studio (SQL-2008), I get...

Oh well, I guess I will open a PSS case with Microsoft... 😎

Here is some more info on this, just to give everyone a better idea on what is going on.

Results from sp_helpfile (focusing on the PRIMARY and IDX filegroups of the...

Any more thoughts anyone? This is very bizarre...

Thank you, much appreciated!

Here is what I get:

Major Minor Build Revision

----- ----- ----- --------

2 0 -1 ...

No, this database was never on SQL 2000. It started off as a SQL-2005 database.

I must admit I've always played around with the MAXDOP setting when I had high CXPACKET waits.

Grant's suggestion is something I had never considered before.

So, if I understand it...

I agree with Grant; best to first stop the SQL services and then restart the server, just to be on safe side.

You never know if by some bad stroke of...

I'm asking because I'm trying to gauge whether it makes sense to be polling this view at regular intervals (say once a day) and storing the results in a table...

I'm sure about the 1st one, and...

Under which account is the full-text filter daemon launcher service running?

You need this service running if your application is using the Full-Text Search feature.

Also make sure that the Named Pipes...

Database finally recovered after about 2 hrs.

Thank you, I'll check.