Did everyone else realise that the original poster solved his own problem - it is the second post in the thread and I have only just noticed it!

Ryan,

If the code...

The problem isn't syntax - it is data related - if the following statement is false then the error will occur

   IF (@vcCname != @in_vcCatname AND @dtExpiry != @in_dtExpdate)

I have...

If a you have a SELECT statement within a transaction than produces an error the transaction is rolled back without any specific indication. You should however get the error message...

I agree with other comments made about error in one of the sql statements within the transaction.

As I understand it if you get an error an implicit rollback takes place...

All the testing I have ever done on this tells me that the lock will not be maintained unless it is within a transaction however I have not done too...

If you wanted to use a pessimistic locking technique and apply a lock to a row at the time you select it then you would need to do it within...

Hi Jeff,

It is not a case of parameterising the view - I would simply use a where clause when selecting from the view.

Select * from vwMyView where Product ='widget'

Regards

John

Antares686. After further tests I can definately confirm your initial response (at least with respect to transactional replication). I am interested in the CommitBatchSize and CommitBatchThreshold arguments to the distribution...

I am also investigating use of replication for a remote sales force. The tests I have done so far suggest the opposite to Antares686 statement. My test publication includes 2...