Oh, it's definitely fixed. Also noted up and across the chain so it can be addressed with any future related issues.

Figured I should follow up with the resolution as I know it annoys me when I don't see it on others' posts.

First off, thanks for the reminder about anti-virus. ...

No worries. I had to read that several times to make sure I was understanding it correctly.

Processor tab: affinities automatic max threads 0, boost priority not set

Nothing else...

Brandie, that's the info I was running off of. Yes, we are having performance issues, which is why I'm looking into all of this.

This part:

If the bpool_commit_target is...

Outer join:

http://msdn.microsoft.com/en-us/library/aa213228%28SQL.80%29.aspx

SQL Server does an implicit conversion for dates when it can, so a recognizable date string such as '12/21/2010' will get converted. BUT, that is NOT what you have...

Note NO QUOTES on my version as well. You don't need them, can't have them. Quotes are ONLY for char/varchar data types.

Also, not sure what you're wanting to...

Well, if you tried it as I wrote it you would receive no error, as that is tested code.

Do you see the differences between my statement and yours or NO?

You...

If they are Datetime, you don't do it as a string.

Try this:

declare @startdate datetime

select @startdate = dateadd(mm,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0))

select @startdate

Red Gate SQL Compare is definitely the simplest, easiest option.

But if that is not workable for you look into using tablediff.

I've used Diagnostic Manager and Spotlight and of the two, I definitely prefer Diagnostic Manager.

The one I dealt with yesterday / last night was the fact that replication thought it was running, but no data was showing up on the subscriber since the reboot.

Log...

Don't forget the old standby, bcp, which can be easily scripted (and is what snapshot replication is using behind the scenes). In fact there are at least a couple...

I knew this one because I've been "bit" by it before. Would indeed be better if there was a warning.

And for the why not create another table and move...

"impacts performance" = makes things run faster. So they are both good for performance.