It was originally added to suppress warnings for the unattended install done by FineBuild. It will also suppress some warnings for an interactive install.

I suggest you try it and...

I have successfully installed DTS Designer on W2008 R2. This needs to be followed with copying the DTS Designer dll files to the SQL 2008 program folders as noted...

As far as I know there is no documented procedure from Microsoft for removing these groups. Therefore if you do remove the groups you may put yourself outside of...

At what point in the install process is this error happening?

If it is right at the beginning before Setup has displayed any windows to you, then you are having a...

I think this is a very helpful article. There is one aspect that many people take for granted, but I think should get challenged more, even if the challenge...

These short videos from Andy Warren give good advice about updating statistics:

http://www.sqlshare.com/updating-statistics-part-1_695.aspx

http://www.sqlshare.com/updating-statistics-part-2_696.aspx

http://www.sqlshare.com/updating-statistics-part-3_697.aspx

For 64-bit Windows 2003, 2008 and above:

/3GB is not relevant to 64-bit, and is ignored if it is supplied.

/PAE is always on for 64-bit, and makes no difference if it...

IMHO the only version of SQL Server that handles international and DST-affected times correctly is SQL Server 2008 when using the UTC-aware data types. If you are not using...

You need to download and install the 'SQL Server 2000 DTS Designer Components' from the SQL Server 2005 Feature Pack.

Many sites find they need to then also apply the KB917406...

You have given the SQL Server erroelog. What is in the SQL Agent errorlog.

Everything in your log file looks fine.

If this works in a script but the same command fails in SSMS, then I suggest you raise this as a bug with Microsoft.

It is normally safe to uninstall the default instance of SQL Server and leave a named instance running.

However, in your situation I would prefer to set the default instance services...

SQL Server picks up the path for the master data and log files from startup parameters.

As far as I know, it will always ignore the paths stored for...

We have active instances on each node of a two-node cluster, but for us they are both EE. One node has our main publisher DBs and the other node...