If the subscription was already deleted try

sp_removedbreplication @dbname = 'dbname'

Usually after snapshot delivery SQL rebuilds all indexes so this is probably not related with replication. Have you tried updating the stats. I am assuming that many execution plans...

Welcome to the DBA Team! 😀

The fact that you can are not using SP2 *is* a big deal.

My only thought is that you should run a sqltrace at the times this happens and figure...

you can create a column with a default of "suser_sname()". You will still have to be responsible for updates though... an update Trigger can do the job.

I am not sure...

add extra drive ?

Issuing a rollback on a logon_trigger prevents the connection from succeeding.

levsha_z (9/4/2008)

---

I'm trying to create a function but getting an error message about the use of EXEC within a function.

I need this function to use it's output result as one...

In addition you could consider peer-to-peer replication 🙂

Previous advice is very wise. Consult with a professional if this is a Production level environment. Replication has many quirks!

parackson (9/3/2008)

---

I don't know why I can't figure this out right now..... been screwing around with it for a little over an hour now.....

I would like to accomplish the...

I vote for Logshipping !

brekher (8/29/2008)

---

I have 2 servers. The OS on both is the same 2003 Ent. SQL 2005 is 64 bit

ENT on one with SP2 and 64GB of RAM and 32...

John.D.Wilson (8/28/2008)

---

It can be done in the following way;

1. Take one fresh, blank install of SQL 2005

2. Add one idiot to the mix (Yours truly:D)

3. Configure Distribution, creating a nice...

seriously doubt that it can be "renamed". On the parameters that can be changed are specified in sp_changepublication which uses...

Rodrigo Moreira (8/28/2008)

---

Hello,

I'm facing a situation that might be a bug.

I have 2 databases, one in brazil and the other in china. Each one replicates all the changes to the...