What is the exact date string you're passing? You may have to run a profiler trace to catch this. And is there any reason your input variables can't be datetime...

Patti - either peer to peer or merge would both give you the same functionality in your case. I"m more comfortable with peer to peer and in my case performance...

Try this

DECLARE @VP_ATTUID VARCHAR(20)

DECLARE @id INT

DECLARE @rowNum INT

DECLARE @maxrows INT

IF Object_id('tempdb..#TempRevenue_GM') IS NOT NULL

DROP TABLE #TempRevenue_GM

IF Object_id('tempdb..#TempRevenue_CM') IS NOT NULL

DROP TABLE #TempRevenue_GM

IF Object_id('tempdb..#SRRANKS_VP') IS NOT NULL

...

I mean run the drop commands, and then run that code. Also, adding...

It's also worth noting that with IIS connection pooling, the spin-up/spin-down time of opening a new connection to pull that extra data is almost nil.

Drop the tables manually, then run it. The query is stopping before it gets to the end (and therefore never actually dropping the tables).

If nothing is working for you, it sounds like you might have some other issues...possibly network related.

Can you ping the publisher from the distributor using only the hostname (not the...

Merge and Peer to Peer are similar, just meant for different things.

Peer to peer was designed for server-server communication where both servers will pretty much always be online. From what...

edit - double clicked...whoops.

I've set it up that way in the past but if you're having issues on your network getting it to work you could always try using a SQL login instead...

When you want to have multi-master, yes it's called peer to peer in sql server. It can technically be up to 8 total servers I believe, but nobody should really...

You will need to use a domain account for this. Pick one and give it the appropriate access on the publisher, and then set the log reader/etc to use that...

If the mirror in synchronous mirroring goes down the principle will still be able to run, so yes you should be fine to pause it, bounce the box, and then...

You're talking about a peer-to-peer transactional replication setup. I'll tell you right now that these can be tricky to keep running reliably, especially if it has a high traffic volume,...

Good to know that it always attempts the default db first before the explicitly stated one in the string. I have a tendency to set the default database to master...