Please stop resurrecting old threads.

This thread is six years old.

If your replies are relevant, there's no need to create sock-puppet accounts to post them.

I hope you noticed that this thread is 5 years old.

It's unclear to me what you want to achieve.

If you're trying to generate the CREATE SYNONYM statements, you can do it this way:

DECLARE @DATABASENAME sysname;

DECLARE @sql NVARCHAR(max);

SET @DATABASENAME = 'master'

SET...

You're welcome.

Glad I could help

You can use sp_estimate_data_compression_savings

Yes, it can be done.

Each partition can be rebuilt using a different compression settings.

ALTER TABLE table_name

REBUILD PARTITION = partition_number

WITH (DATA_COMPRESSION = NONE|ROW|PAGE)

I suggest that you start a new thread. Very few people monitor old threads.

Do publisher and subscriber have the same server collation?

Many ways to troubleshoot a Linked Server can be found in this article: http://www.sqlservercentral.com/articles/Linked+Servers/73794/

2,5 GB for the OS might not be enough.

Also consider that you're controlling just single page allocations with Max Server Memory. All other allocations are not included in that figure.

See...

Ok, so no resource exhaustion event.

You should monitor the memory counters in Windows and see if they get too low.

If this is a SQL Server only box, you could lower...

Is this a SQL Server 2005 or 2008?

I'm asking because you posted in the 2008 forums but you said it's a 2005 instance.

However, if you have many insufficient memory errors,...

In general, it's not a good thing. In case of a clustered...

I have no idea. It is maybe pointing to a different schema/database?

It's hard to know without tracing what the provider actually tries to query.