http://sqlaj.wordpress.com/2010/01/12/t-sql-tuesday-002-a-puzzling-situation-the-package-failed-to-load-due-to-error-0xc0011008/

Looks like you need to edit the package in the new edition and save again. Or follow the instructions in the link

Post the actual execution plan for both the job and the normal run

SELECT TOP 1000 qs.*, qt.text, qp.query_plan

FROM sys.dm_exec_query_stats qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt

INNER JOIN sys.dm_exec_cached_plans as cp on qs.plan_handle=cp.plan_handle

CROSS...

http://techpunch.wordpress.com/2008/08/29/sql-server-2008-installing-the-adventureworks-sample-databases/

Follow the URL for instructions on installing Adventureworks. You'll need to add Full text to your existing install in order for Adventureworks install to succeed. You also need to...

update tablename

set column = NULL

where cast(column as int) < 0

You can use sys.dm_db_task_space_usage to see tempdb objects. But if you're looking for more general performance statistics of tempdb, you can use performance monitor, info here: http://technet.microsoft.com/en-US/library/cc966545.aspx

This query will...

Yes that is the correct order of steps, however you dont need step 1, it's fine the way it is. What you are doing is creating 2 failover cluster...

RDP into either of the nodes and open Failover Cluster Manager, expand Services & Applications, right click each one and "Move this service or application to another node"

The trigger will execute in the context of the user. Does the user have permissions to the view "VwBPAssumption"?

You need to restore the FULL backup first WITH NORECOVERY, then the latest DIFFERENTIAL backup WITH NORECOVERY, then all the log backups starting from the last differential to the last...

You dont need to store the count of events, it should be worked out on the fly by a query or stored procedure. You could do it with a...

Have a read through this: http://support.microsoft.com/kb/173907?wa=wsignin1.0

The local regional setting has no affect other than how dates are displayed to the user in SQL.

Profiler (running on which machine?) is...

When the date is specified in ISO format (reverse date yyyy-mm-dd) SQL will interpret it correctly. It will not accept yyyy-dd-mm (day and month swapped in reverse format) as...

You need to patch both physical servers, starting with the passive nodes. When you run the SP, it will show both instances can be upgraded at the same time...

It sounds like you've setup an active-passive cluster with a single instance of SQL Server running on node 1. Node 2 is part of the cluster but not running...

That's an exchange generated error message, not an SSIS problem. Something has changed in exchange/mail server end specifically blocking the connection attempt.

http://stackoverflow.com/questions/12732859/the-server-response-was-4-3-2-service-not-available-closing-transmission-chann