Try to minimize the use of triggers as much as you can.

ahutch (6/6/2008)

---

Is this post-sp2 or something? What summary tab (F7)? (Prepared to...

Can you check if the constraints are DISABLED ?

OBJECTPROPERTY ( id , 'CnstIsDisabled')

If you don't have such "timestamp" column you are probably out of luck 😉

Kaushik Kumar (6/6/2008)

---

Currently I have a stored procedure that accepts a list of columns as the input and upon execute, selects these columns dynamically from tables. This is just the...

A word of caution either make sure you have frequent transaction log backups or enough log drive space.

😉

cheers.

select * from table

where desc like '%\_%' ESCAPE '\'

If you are planning to do this on the Subscriber then nothing prevents you from doing it. Now if you are talking about changing the Publisher, I believe you (...

Once again. Steve is correct. Transactionally commited data will remain in the database. If comunication link is broken, clients could potentially "see" the "partial" state. Merge replication is to be...

Try:

Exec sp_helppublication

wjones21 (6/5/2008)

---

The Number of Commands in the Distribution DB waiting to be Applied to the Subscriber is NOT going down and the and the Estimated Time to Apply These Commands...

zafar (6/5/2008)

---

I am using Merge Replication.

when synchronization was in process , i disabled the netwrok connections

then replication was stoped, but the subscription DB wasn't Rolled Back.

How the Subscription DB is...

aparna_v19 (6/4/2008)

---

I need to configure snapshot replication (Pull) on Enterprise Edition of SQL Server 2005 (acting as Distributor, Subscriber) for Sybase server (acting as Publisher). I have the Sybase ASE...

If it...

jananik (6/5/2008)

---

Yes teh indexes are used in the where clause, a glimpse of the query. Highlighted are the indexes used:

Createddatetime uses clustered index and sid uses non clustered

SELECT * FROM...