Not sure it this will help but I had a similar problem with an external 3 tier app, the app was connecting to a service and the service was trying...

Just to clarify, the SQL Server Health and History tool works with both SQL Server 2000 and SQL Server 2005.  However there are a few small issues with SQL Server...

You could look at implementing DDL auditing which is now supported by SQL Server 2005.  I have started testing this type of auditing in...

Have a look at a free Microsoft tool called "SQL Server Health and History Tool", it has a component which allows you to collect any performance monitor counters.  It is...

The same question has come up in a previous post, http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=359&messageid=339254.

The short answer is that if none of your SQL Services are using...

I agree with Markus, under normal circumstances it is usually not necessary to rebuild all your indexes every night, even on very busy systems you can normally get by...

Should work, I know that you can host a Reporting Services 2005 instillation on a SQL 2000 Database Engine instance.  So unless you specifically indicate that you also want to...

Hi Robert

It is possible to change the collation of the tables you have already created using the ALTER TABLE statement. Keep in mind however that you will...

The "Backup set will expire" option just indicates for how many days SQL will be prevented from overwriting the backup set.

Another thing you can try is to open...

I think what they are referring to is the ability in Enterprise Edition to build, re-build or drop indexes while keeping the underlying data online.  This...

As far as I know you can only upgrade if you purchased Software Assurance with your original 2000 licenses.

Hi

This sounds like a known problem with the original release of SQL 2005, see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1.

Hi Brent

Make sure that you have not include the “.” in the file extension.  Also make sure that you select the correct folder and...

Microsoft has just released a tool which will generate a script file containing both the schema and data of a table.  It’s called the "Microsoft SQL Server Database Publishing Wizard 1.1"...

To answer the second part of your question, you cannot change the collation of a database server instance, i.e. the system databases.  This is selected when you installed the instance...