You can try one thing first register the publisher in enterprise manager on subscriber then use that name for configuring your subscription

Note: - all this steps & replication configuration should...

What i think is its something to do with the memory management on the server.

You can monitor the server for memory utilization by ASP & how the pooling is handled...

Subscriptions are set to expire because in case you configure a replication for temporary purpose after which you forgot the remove the subscription then in this case the publisher will expire...

Yes, it is possible to replicate between different domains.

The easiest way to set up replication between different domains is to create a local user account on both the servers with...

You can even check for the application user access to the DB OR Stored Procedure.

I think 2 things can be done here.

1. access remote db from link server.

2. First dump all the records in #temp table from select & then update the main table...

Try this...

sp_helptext sp_who2

Check OSQL user for valid permission on prod.

Check the account by which your service was running OR try starting it from different account.

I am not very sure why OS will change the way query is writen in SQL server.

I think you just need to set the "SET QUOTED_IDENTIFIER ON"

for more info...

It really depend's on your query & the table which you are accessing. if you are selecting data from a huge table then tmp table is the good opction as that will cut...

varchar[(n)]

Variable-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is the actual length in bytes of the data...

This link might help you.

http://support.microsoft.com/default.aspx?scid=kb;en-us;246133

Sushila,

Thanks for the link, it was nice to read that.

IF it's a text column having data less then 4000 char then use this

REPLACE(CAST(<column_name> AS Nvarchar(4000)),char(13),char(10)) AS column_name

Or if its a varchar column then try this.

REPLACE(<column_name>,char(13),char(10)) AS column_name