Did you try detaching the database or dropping the database?

You may find this discussion useful.

Hi Brian,

UPDATE STATISTICS does not have MAXDOP argument like ALTER INDEX. You need to include the sp_configure script in between. Here is an example.

sp_configure 'max degree of parallelism', 2

go

[UPDATE STATISTIC...

Here are some of the options for SSIS.

Do you find any subfolders like "20101122_*". The Detail.txt file should be located inside those.

Check the Detail.txt located at "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log" for more information related to this error message.

You connect to SSIS, SSRS using SSMS. After connecting at the right side of the service, the version information is displayed as in this screenshot.

Standard template should capture it. I tried it here

@Patti,

Since you are running trace it should capture TRUNCATE_ONLY. Try using fn_trace_gettable, it makes reading trace files easy.

Yes Ravichandra, I would leave it at 0

It is better to leave this settings to Dynamic. Also the link that you had provided mentions how SQL Server calculates that value "automatically".

Since this question is...

The default value is 255. Please refer this for more information.

Operating System Error 32 means "The process cannot access the file because it is being used by another process." Please check if any process like Antivirus or the Tape backup...

Denise McMillan (11/19/2010)

---

One of the final steps after upgrading SQL Server from 2005 to 2008 says to register your servers. Can someone help me with how to do that. I...