Another thought - have you confirmed that the Agent account has read access to the SQL Server program libraries, and that the Agent account is a known login to SQL...

You can use Security Configuration Manager (a W2003 tool) to build the existing permissions.  The default is that everyone can read the Event Log service details but if your site protects...

There are 2 undocumented permissions that SQL Server 2005 needs in order to run correctly.  Most people do not hit these, but our service accounts are NOT Local Administrators and we...

I suggest you also install the client tools on Node2.  This way you will have a working client if Node1 is down.

Our Cluster Install standard is that following an install...

We have built a single install folder for SQL Server 2005.

Stage 1 - Copy the contents of CD2 (The Tools folder on a DVD) to your install folder.

Stage 2 -...

I do not have a SQL7 system available to try this, but I suggest you do it and see what happens.

The edition of SQL Server 2005 should not make much...

If the user is a member of a DOMAIN\SecurityGroup that has Sysadmin authority in SQL, then that will be used when accessing databases.  Otherwise you need to look at what DOMAIN\SecurityGroup(s) have...

If SQL Server 2000 looses connection with Exchange and tries to do a xp_sendmail during this time, the xp_sendmail interface can get disabled until SQL Server 2000 is restarted.  There is...

If you take a SQL 2000 master database and somehow make it a SQL 2005 master database you are heading for trouble.  There are significant changes in the data structures...

If you have restored a SQL 2000 master database to SQL 2005 and got SQL 2005 to start, then well done!  Just don't expect it to perform well or for...

What is your buffer cache hit ratio?  If this is below 90% then your problem lies at least as much with memory as with disk.

If you cannot fix the problem...

When you create a new clustered index, you are rebuilding the table.  The entire table is copied to build the clustered index, and on 82M records this will take some...

Applying HF 2187 will stop and start your SQL service.  Therefore plan to apply HF 2187 when the outage will not affect your applications.

I think identity management the greatest IT challenge of the next 5 years.

We currently have a situation where multiple sites hold sensitive data about individuals.  Each site decides what information to...

I have seen posts from people saying that are running SQL under VMWARE in production with no issues.

However, you should be aware that the main thing any database needs to...