My guess is no. It looks like the hotfix logs are stored in the folder created when you installed the SQL Server service.

Why did you only allocate 10 GB to...

To see examples of what might break between earlier versions of SQL against 2005, try this link: http://geekswithblogs.net/influent1/archive/2007/01/04/102774.aspx

There is one simple example of getting different results depending on compatibility levels...

As promised, here is the resolution for this problem:

1. SP4 was installed on the offending server;

2. DBCC CHECKDB and DBCC CHECKTABLE now showing the same error; that is, the message...

Thanks Paul - I was hoping you might be available to help out.

I have just moved to a new OPS team, still on 2000 SP3. Not sure why they have...

There are a number of ways to prevent changing the name of a table - as highlighted by the previous posters; however, the answer to your question is that there...

Firstly, this question should be posted in a different forum - like Newbie or Development!

If I understand you correctly, what you want to do is to execute a sql statement...

Try searching this site under 'orphaned users'.

Paul

I presume you are suggesting that creating a new account in AD does not present a problem, but recreating a deleted account does?

My AD knowledge is a bit flaky, but...

There could be a number of reasons for your problem. To troubleshoot, please follow this link: http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1186920,00.html

Paul

There are a number of restore options in 2005, including complete, partial, file and page restores.

If the table resides in a particular file and/or filegroup, there are other files and...

Also, a UNIQUE CONSTRAINT will allow one NULL value, whereas a PRIMARY KEY cannot accept a NULL value.

Paul

Try rewriting the query after you have had a look at the query plan.

Release more memory to SQL Server by either adding more memory and/or use the /3GB switch....

Speak to the System Admin guy and see what tools he use for monitoring the network and how much of that is useful for the DBA.

Use a Monitoring tool specific...

Try using DATABASEPROPERTY() function with the 'IsOffline' property.

Paul

A company called IDERA has a SQL Monitoring product that will alert you to most of the issues you want to monitor in your list.

Paul