Add the -SkipErrors parameter to the Distribution Agent of a specific subscription.

Welcome.

Thanks for informing that it worked.

Change the connection string in the .dtsConfig file.

It is an XML file. You can edit it with text editor (such as notepad).

It may not be saved along with other package...

Add parameter @body_format = 'HTML'

Oracle_91 (8/11/2011)

---

I intentionally have'nt provided the commit stmt. I wanted to keep that as a open tran.

I was expecting the CKPT to do that for me. I was basically trying...

tt-615680 (8/10/2011)

---

Hi All,

I'm trying to work out how to find out where and how many times a particular stored procedure is located, I thought I can find out in the...

The code...

Also check

1) Protocols

2) Firewall settings

2) If you create a new table at the Publisher, it will NOT be replicated to the Subscriber automatically. You have to manually add it to one of the publications.

If...

Is there any other application on the server?

You can reduce the max memory from 14 GB to 12 GB, so that OS and other applications have enough memory.

Out of 16GB, 4GB is available for OS and other applications. That is ideal amount.

I suggest you set SQL Server max memory to 12GB.

Why do you want to release...

Replication from SQL Server 2000 to SQL Server 2005 is possible.

But I am not sure about the encryption part.

What kind of encryption is implemented?

You can ATTACH the .mdf file.

.ldf file will be created automatically.

Microsoft Office Excel 2007

Thanks Srinath for sharing your experience.

Here, I have a question for you. Why does your production SQL Server service restart DAILY?