Actually IIRC, all of the databases involved in replication can be set to simple.

I've never done this on the publisher/subscriber since any database important enough to be replicated is typically...

Check your parallelism. You may have been doing something like maxdop 1 on 2000, and 0 on 2005, which can cause huge performance swings (in either direction).

Also do a full...

SKYBVI (10/5/2010)

---

@ derrick

So, that means if it does ping successfully, then no need to check configuration manager?

OR

both are different and have to be checked seperately to ensure proper working...

Shouldn't it be something like

INSERT INTO INVOICES

VALUES (xx,xx,xx,xx)

There is no Values or Select in your statement...I've never tried without it but I would imagine that would throw an error.

The services could be running...

To check to see if SQL is connectable, your best bet would be trying Telnet to the port it's on

i.e. if you're using the default instance, open a cmd prompt...

Wait, we need "reasons" for this kind of thing now?

Since...

http://msdn.microsoft.com/en-us/library/ms177596.aspx

This works for me fine...syntax-wise anyway. All I did was change the data types to nvarchar(50) (adjust to the proper sizes based on data).

BEGIN

DECLARE @strQuery NVARCHAR(MAX)

...

Michael Valentine Jones (9/30/2010)

---

That was my point. You don't have any backup on disk from 10 pm to 2 am, which is one sixth of each day, so you...

And unlike SQL 2005, you can actually uninstall a SP in 2008! woo!

We used to have peer to peer replication in SQL 2005 SP2, and I upgraded to SP3 without...

This is possibly the scariest title I've ever read on a forum post.

If they have the SA password, what's to stop them from just restoring a backup to another name or on another server and having all the info there? Or creating...

Tracing to a file sounds like the best option then.

I take it there's no way for you to just explicitly deny select on any tables you don't want them accessing?

Is it the default instance? Using a static/default port (1433)?

If so, could try adding a hosts file entry for it, since you can't do replication via IP/FQDN/etc. I've had to...