Using performance monitor I find that Reporting Services is sending the entire report (including drop down parameters) each time a parameter is selected that causes the next drop down parameter...

Nirmala

   From what I can see is that all of the configuration files are all set when the package loads.  This is the reason that the last...

You could also migrate directly into a BIDS solution.

Right click on Packages node in solution explorer and select Migrate DTS 2000 package.

     Rick

Thanks Kaddie

   I walked through and was able to get this to work.  This will allow me to control connections from the Parent process.

   Thanks!

         Rick

Some of the Microsoft SQL Server 2005 ELearning is still free until the end of the month.

Each course takes about 6 hours.

Check this link out: http://www.microsoft.com/learning/2005/sql/dba/default.mspx

           Rick

The application does an update by joining the 100,000 rows from the base table to a table in a staging database.  On the publisher (where the original update occurs) it...

I was able to register for both of the exams on the Pearson VUE web site last Friday night.  I did not like the drop in a mailbox (late on...

I agree with Jason that you should run the backups as a train (one behind the other).

A way to determine that that backup is running is to look at the...

Ramesh & Chris

   I believe that I will be able to activate free 90 day licences on all of the SQL2005 courseware prior to the end of the free period.

  ...

DBCC Shrinkfile is transaction safe.  You can cancel it at any time.

We would have to cancel this process when the shrinkfile failed to finish during the "quiet" time.

       Rick

Yes, it should have been installed from the SQL Server 2005 Developer Edition Community Technology Preview CD.

It is located on the start menu under "Microsoft SQL Server 2005 CTP" as...

Are you sure that the tests are the same between the Intel and AMD. 

Have you loaded both databases from identical copies.

Is your recovery model the same on both servers?

Is...

The AMD was purchased just to test the 64 bit software for Data Warehousing.  It is only a test machine that cost $1,050. 

The machine outperforms the Intel 3.2 GHz...

The documentation states that you must drop and recreate the user defined type.  They claim this is due to indexing issues.  So in order to drop the user defined type...

There are some screen shots in this document:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/SQL05InSrREAL.asp

Or if you have the SQL 2005 Beta (or CTP) installed see the tutorials.  The Integration Services Information...