Thanks for your response! It is interesting how compatibility level plays out. I did try putting the subscription level at 100 compatibility but had the same issue. I think I...

OK, I'll add some context here. Both servers are at SQL Server 2008 R2. The source database is in 2005 compatibility mode and the source database uses the System data...

There is an error in my last post because it was looking at a different table.

Here's the correct first line:

DECLARE @ChangeVersion bigint = (SELECT CHANGE_TRACKING_MIN_VALID_VERSION(OBJECT_ID('c_table_data')))

Unfortunately I failed the 70-450 exam by one question. I've been taking some time off but am considering taking 70-450 one mroe time. I'm waffling a little because we're now...

<According to the Microsoft Learning website 70-450 will be retired in January next year, which does give you a bit of time yet. The dilemma would therefore be whether you...

Thanks, Koen, I've heard good things about Pragmatic Works too. I'll look into them more.

Hi Duncan,

I've passed the 70-432 so I have a MSTS. I recently took the 70-450 and failed it by one question, which was extremely frustrating. If there was more time...

Thanks for the input. I'd really have to use an established company in order to get my boss to fund the training. I have found a possible class from Global...

Thanks, Duncan, all very good advice. I'm just starting on the certification path and have found the exams really hard. I'm still trying to figure out my best method for...

I'm in Oregon, on the US west coast. We're looking for a high level overview class on SQL 2012 BI.

Duncan, thanks for the great information! I appreciate your input. Have you used any practice tests? I've used the ones from CBT Nuggets, which were way too easy and also...

I was thinking of transactional replication as well. I was going to do snapshot replication as a temporary fix and then implement transactional later. Mirroring plus snapshots is a good...

Wow, I'm really bummed. Sure looks like it's 3 more exams after finishing the 2008 MCITP. Below is the upgrade path for the SQL 2008 DBA cert. I'm still going...

Very nice article. I didn't know the bit about the log_reuse_wait_desc. In the situation today, SharePoint had a nasty piece of code which was deleting everything in sight. After I...

Fabulous. Thanks so much.

Elizabeth