geervani (1/5/2010)

---

U can use Between clause or datediff will be best i feel because between will not include the startdate and enddate.

But i am not understanding you question. Each record...

Have you tried "ALTER DATABASE database_name SET PARTNER FAILOVER"?

Use CREATE TYPE instead of SP_ADDTYPE

What is the purpose using a transaction here?

Apollo74x (12/21/2009)

---

Suresh B. (12/17/2009)

---

Why is a complete snapshot being generated when a new article is added (SQL 2005)?

--------------------------------------------------------------------------------

This is expected behaviour if you have a merge or snapshot publication....

Why is a complete snapshot being generated when a new article is added (SQL 2005)?

--------------------------------------------------------------------------------

This is expected behaviour if you have a merge or snapshot publication. If you have...

Also, databases in restoring state (log shipping/mirroring?) are displayed...

Are you trying to create maintenance plan to backup transaction log and are these databases in simple recovery model?

Grant permission to the SQL Server service account to access the folder.

Hi...

Roy Ernest (11/25/2009)

---

Is it failing? The distribution agent clean up Job?

Try running the the clean up job from the SSMS under your Account and see if it is giving any...

glugingboulder (11/24/2009)

---

Just a thought, its possible that the distribution clean up agent is running under a account which doesn’t have permissions or doesn’t exist anymore worth checking.

Therefore isn’t cleaning up...

Ian Scarlett (11/25/2009)

---

Is it the distribution database itself, or the transaction log that is growing?

If it's the transaction log, check the recovery model. If it's anything other than simple, you...

Thanks Kashyap,

You...

Thanks Gail.

Is replication...