If the SSIS package you are running fails, the execute SSIS package task itself will error. If you have not increased your max errors properties, the main package will...

SQL 2005 caches many query execution plans as well as stored procedure plans. Stored procedure plans persist longer where query execution plans get flushed and replaced based on things...

There is another property on the toggle item. It is toggle state or something like that.

Also, for reports that are relatively static throughout the day, you may want to schedule them to execute and store copies on a server at the site the users are...

Why aren't you just using the IN with a select statement - or with a join?

SELECT * FROM MyTable WHERE MyValue IN (SELECT MyValue FROM MyList)

SELECT T.* FROM MyTable T...

That sounds logical, but unless you are looking at report history or you are storing copies of reports, the report server does not seem to cache much. It does...

In most cases, you want to keep the RS server at the same site the majority of the data is at. The output of the report will typically be...

You can join a table to itself.

Here is a sample, the join with a function in it may be a performance issue.

[font="Courier New"]SELECT

A.Col1

, A.Col2

, A.Col3

, A.DateCol

, B.Col1

, B.Col2

, B.Col3

, B.DateCol

FROM

MyTable...

DBCC LOG(-DATABASE NAME-,-DETAIL -1,1,2,3,4-)

You cannot log ship from SQL 2000 to SQL 2005. You could apply the logs in NORECOVERY mode leaving the database unreadable until you apply the final log and...

SSIS, SSRS, and many other tools are going to have some trouble with these. The problem is that SSIS does not actually execute the procedure when it is trying...

If all you have is a backup of the master database, you can recover the original Master database from the installation media. There is a switch to recover a...

Is it on a file share that is not on the SSIS / SSRS server? This too requires authentication unless you set the security group on the sahre and...

Is there a data source in the SSIS package that is using NT authentication and not the server SSRS and SSIS are running on?

If your package is pulling data from...

But remember that the "pipe" being referred to is the one between the SQL Server and the RS Server. They could be on the same machine or connected to...