Does anyone have a method for returning the time value of the datetime field?  I have been doing this with a character conversion:

set @loop = 1

set @dStart = getdate()

--uses convert...

I have been battling this same problem for a while now.  I have hardware people checking into our hardware configuration and have implemented  several patches...

I did this a little while ago.  I was stuck because you have to drop the constraints on the replicated column before you can drop...

Marcel,

Are you using pass through queries to get your data?  Pass through queries are normally what is used to call stored procedures.  You can insert SQL in them as well. ...

Sorry, I should have said piling up in the log, not the distribution database.

You can try restarting the log reader agent.  The transactions are probably piling up in the distribution database so you do not need to do a reinit.  To...

If I understand you correctly, you want to join and Access table and a SQL table in Access.  If this is what you want to...