Hi,

Can you access SMTP server outside of SQL Server?

Thanks,

Phillip Cox

Hi,

Please bear in-mind the "Estimated Execution Plan" is exactly that, estimated, thus not accurate vs "Actual Execution Plan". Here is some further reading, you may find helpful.

http://blog.sqlauthority.com/2007/08/28/sql-server-actual-execution-plan-vs-estimated-execution-plan

Cheers,

Phillip Cox

Hi,

Create a transactional or snapshot (if you have scope) publication on database 14 and include the lookup tables as your published articles. Once this is done, on each of...

Hi,

Yep, this is possible. Here is a link, which provides an overview of process:

http://support.microsoft.com/kb/224071

On point to note, if the servers are in different domains, you will need to ensure...

Hi,

Sorry, but this would not be caused by SAN cache and seems more to do with transaction logic. Regardless of whether the data resides in SAN cache or on-disk,...

Hi,

You would want to leave at least 1GB for operating system, but 2GB is better to reduce OS paging. So, you would set SQL Server to 14GB and retain...

ok, this is great information.

If possible, could you show execution plans or advise on the differences and update me?

Thanks,

Phillip Cox

Hi,

Have you ever been able to connect to subscriber using any authentication method? If not, check you have access via your firewall (e.g. port 1433).

Hope this helps,

Phillip Cox

Hi,

You would just add to publication and create a new snapshot. In terms of on-going changes, you should use ALTER ????? command, as explained in following article:

http://www.replicationanswers.com/AlterSchema2005.asp

Hope this helps,

Phillip...

Hi,

Has this worked in past?

This indicates an issue with your merge agent and ability to locate schema file (e.g. .sch) in the snapshot folder. I would also ensure you...

Hi Bruce,

Don't give up just yet!

What is the specification of the distribution server, including memory, disk and network?

Thanks,

Phillip Cox

Hi,

Have you tried un-sharing the snapshot folder, then deleting? Even better, have you considered deleting files that are not required to control space usage?

Hope this helps,

Phillip Cox

Hi,

This topology is possible, where you have Active---Active---Passive SQL Server instances. The key will be your fail-over policy, which in worst case of both your Active servers failing, the...

Hi,

Have you reviewed execution plans on both servers?