As I wrote before look in Books Online and you will find all the details. As an alternative see http://support.microsoft.com/kb/830210

What error did you get exactly?

Was it really an error or just a warning. If I remember right, you get a warning if you have less than 1 Gb...

You can add a new table to an exisiting publication using the stored procedure sp_addarticle. See BOL for details.

I have no experience with workgroup edition, but since Books Online only mentions explicitly that database mail is not available for Express Edition, I would expect that it will work...

To answer you're questions

1) Yes, you can also search on BLOB data and documents like .doc or .pdf files stored in your database.

2) Implementing it is pretty easy, though...

You cannot install Enterprise Edition on Windows XP.

Only Express and Developer Edition can be installed on XP.

Developer Edition includes all the features from Enterprise, but for Reporting...

Most likely case is that the twqo databases have different default collations. Even though they are on the same server it's possible to have different default collations for each database.

Anothwer...

SQL 2005 has a default trace running which you can use.

An even easier option is the "Schema changes History" report in SSMS.

Yes,

whenever you add (or reinstall) a feautre of SQL Server you need to reapply the service pack.

Which features you can or cannot install depends on a couple of things like the OS you're using, is IIS installed or not (necessary for RS),which edition of SQL 2005...

Did you install any service pack after re-installing Report Server. Probably the database engine (which you didn't reinstall) is on a different built-level than RS.

So before reinstalling everything try...

You need to use the SWITCH option.

Something like ALTER TABLE myTable SWITCH PARTITION to ...

There's a really good whitepaper available here

First I'd like to make clear that Auto update statistics does not reorganize your indexes. So you should schedule a job to do those. The database option auto update statistics...

As I wrote already before the noise word list is just an text file called noiseENG.txt and it is located in the FTData folder of your SQL Server installation. Have...

It's the same answer. You search only on words which are in the noise word list.