You can't use case for tables names in the from clause, only for columns. To avoid dynamic SQL you could create to SELECT statements (one for each table) and use...

If you can connect with the name of the server with QA, or ping the server, you shouldn't have any problem. If you can ping the IP address, then that...

You can select wich sp to replicate to the subscribers.

I would suggest that you create multiple publications in a test server, and check all the posibilities of...

No. You could create triggers or a trace to start finding wich tables are acceded, or you could backup the tables,drop the tables and see if anyone complains...

If you have multiple processors you can speed up your backup by adding more backup files.

You could create a cursor FOR SELECT name from sysobjects WHERE XTYPE = 'P' and then execute the Grant sentence to the user or the role posted before.

Try saving the dts package with no schedulle, and then create an schedule job with the DTSRun cmdline utility. See if it works.

But the number of files to backups depends also of how much processor capacity you have. Because multiple backup files enable sql to backup in parallel. And be ware, because...

That was my mistake, I wanted to say xp_sendmail, not xp_cmdshell. And I also forgot to execute the xp_sendmail. So execute this:

DECLARE @cmd AS VARCHAR(1000)

DECLARE @email AS VARCHAR(50)

DECLARE curEmail CURSOR...

Well if writting a few letters of code is not a problem, I would said you close it and then deallocate it. If you only close it, you can still...

Maybe you should check for diferences with the other servers, service pack, net library configuration, protocol used, etc.

There are several ways. First choice, you could upgrade your SQL server 7 to 2000 (or other server) backup the db, ans restore it in the SQL 2000 server.

Second you...

I don't know much about analysis server, but i would check for differences from my machine with the others from where I can connect. Net library, protocolos, drivers version, etc.

...

You mean you have you sql server in an server and all the data and log files in another server?

It doesn't matter where you have your data files, you must...

With replication you can use a DTS package to transform the data before inserting it to the subscribers.

So you should create a DTS package to transform the data to fit...