To me, this looks like a data presentation issue that really you be handled by Crystal Reports.

Personally, I am not all that familiar with Crystal Reports, but the equivalent in...

Replication is quite happy to have different table definitions on the subscriber.

You will need to be careful if you need to deliver a snapshot to the subscriber -...

There is only one circumstance when an index will not be updated and that is when the index is disabled. If it was disabled, it might as well not...

Implementing replication shouldn't have any affect on your backup / restore strategy. Depending on how often the logreader agent runs, transaction may remain in the transaction log longer than...

SQL 2005 will replicate stored procedures, view and user defined functions. You may get some problems if they reference objects that are not on the subscriber (e.g. a view...

All SQL Server databases are made up of .mdf and .ldf files. The start of the file name is usually the name of the database. Search you PC...

Having you consider creating a snapshot publication that contains just stored procedures ?

You can then just re-initialise this publication as required

The database backup includes everything from the original database.

What you don't get is things such as logins which are server level items and, typically, these are in the...

The message you got telling you to run RECONFIGURE is always output from sp_configure.

The next command was the RECONFIGURE so you should be OK to continue.

The chart has a visibility property. I assume that you are already using that which is leaving you with some empty space on the page. Try putting the...

The article you included in your post said that the location is...

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.n\MSSQLServer

You didn't include the "MSSQL.n" part of the location. This value is probably "MSSQL.1" but it...

The article you included in your post said that the location is...

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.n\MSSQLServer

You didn't include the "MSSQL.n" part of the location. This value is probably "MSSQL.1" but it...

I suspect that the problem is because all data from the tables is being copied to the SQL 2005 server, then the joins and filters are being applied.

You...

I would choose Option 1 ... or something like it. I would arrange a time when the table is not being updated, drop the article/subscription, do the ALTER TABLE...

This is possble using DTS. Two options I can think of are

1. FTP the files to the local server and then import them

2. Use a product such as samba...