actually you don't need to uninstall, you can upgrade

http://msdn.microsoft.com/en-us/library/ms143393.aspx

yep, through add\remove programs. No problems encountered, and this included database engine, SSIS, SSRS and SSAS.

no special preparation or tricks used.

10.00.2710 (SQL2008 Sp1 + CU1)

IF the transaction log of the primary is available when the primary fails run a backup of the tail of the log - that is

backup log dbname to disk =...

select ename, sal from employees where job_desc = 'dba'

works for me 🙂

In SQL 2005 and before, local admins (via the group builtin\administrators) were automatically granted sysadmin rights in SQL as part of the install process. You could then remove\reduce these rights...

if this is via an application ideally there should be no direct access and rights are controlled via the code (which to me means stored procedures and exec rights on...

should make for an interesting series.

How do you turn off rules in the optimiser?

Or is that something its best not to know? (or put in print) 🙂

that's typical, blame us! 😀

as this is in 2005 forum..................

SELECT SDER.[session_id] as SPID,

CASE

WHEN SDER.[statement_start_offset] > 0 THEN

...

a link on how to make SSIS 'cluster aware'

http://dougbert.com/blogs/dougbert/archive/2009/04/09/ssis-and-clustering-what-you-should-do-instead.aspx

try this. Written for SQL7 but works equally well in SQL2000.

worked seamlessly for me for years.

As these settings are at the database level you should turn them on again after the load if you have other tables outside of the ETL process.

Only true way to...

No matter how many of SQL instances are installed on a box there is only one install of SSIS. This is used to service all the SQL installations. I am...

SP3 install I would say.

This could be related to not installing with an account with local admin rights?

Have another look through the error log, any other errors which narrow down...

you get 2 node support for clustering with the standard edition of SQL (2005 and above), not the standard edition of windows.