You could do INSERT/UPDATE/DELETE on subscriber but then your data could be out of sync with your publisher. There is a bi-directional replication in SQL 2005. Its called Peer-Peer Replication....

http://www.replicationanswers.com is a good resource. I havent yet seen any step-by-step guide anywhere. I did a brief to-the-point write up an article on setting up Trans-Rep from a...

Your @commandstring seems to be getting truncated. Increase the size to 4-5000 and do a PRINT @commandstring to see how its getting built.

you could do an

INSERT INTO table1( col1, col2, col3)

SELECT col1, col2, col3

FROM table2

AFAIK, you cannot do this with functions. Here;s an arcicle from MS with a workaround : http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319138

25k rows is not much. You shouldnt have to delete indexes and re-create for that count. You could however disable triggers and see if it helps.

when you configure distribution on the node it will add the distribution_admin user for you.

make sure there is enough diskspace in that folder as it can get filled up prety quickly sometimes, especially when you reinitialize or add a new article etc.

also, the...

yes it would but it would take a very long time to feed all the data through the app and let it encrypt and put the data in the table....

If you use dynamic sql you would not be able to use table variables. You need to use either temp tables or physical tables. there are tons of articles about...

Check out BOL for different views under INFORMATION_SCHEMA.

You could create an index on the name column too. And if it still doesnt help you can force SQL to use the index on the name.

The following example shows...

Create a domain account that is also a local admin on the server and use that account.

There is a creationdate in sysobjects. am not sure if you can find the "modified date".

You might need to use dynamic SQL and use EXEC() to execute the sql.