When you do the initial install, if you go through the advanced installer, in one of the sub-sections of the installable products you will find that regardless of your initial...

No, it's not, so scratch that option.

You are in a SQL 2005 forum, so I figured you were using 2005.

Calling a DTS package from a trigger is creative, but a bad idea. The trigger is part of the original transaction, so your original record is not committed...

Global temp tables are not the devil, but in your situation, I think they may be more trouble than they are worth. Since you are really trying to work...

When you "write" to an updatable view, the query optimizer figures out the underlying table and writes to it. You obviously cannot write to a view because it does...

If you mean "Database Snapshot" from your mirrored database, what you are suggesting will not work.

I think you are over-thinking this. Mirroring is made for failover.

Here is an article...

Clearly by the number of reads, you are getting different execution plans.

Grant is correct, start with statistics.

Also check your parallelism threshold. You may want to try running the query...

[font="Arial Narrow"]"are set to correct values after the package has started executing"[/font]

This is not correct. Package configurations are set before validation. Then validation is run, then pre-execute, then...

I assume you got the FileWatcher from SQLBI.com.

You need to have the package constantly running. This is best done by creating a SQL Agent job that starts when the...

Search this site for information on the undocumented system procedure:

sp_MSforeachdb

I am not sure a local temp table will not work, so you should try it. When the query is run, it is executed by an extended stored procedure...

There is a new type of bulk-insert as well. If your destination is the local SQL server, you can use the "SQL Server Destination" component. This does a...

It looks like you are using an "OLE DB Command" component rather than an "OLE DB Destination" component. Is that correct?

If so, I think you have a data type...

Yes, you can modify the mail procedures in MSDB. It is fairly simple, so just open the procedure and look at what it is doing.

Remember that any patches or...

I am not sure why you would have used VARBINARY(MAX) rather than a blob field, but the answer is to stream the TextStream to a file and launch Excel giving...