You've just gotta love people that give a super low rating to an article or QoTD without leaving a reason.  🙁  I thought this was a great question because...

I agree with Frederico.  This

Databases with a compatibility level of 90, including backups taken on SQL Server 2005 (9.x), are automatically upgraded to a compatibility level of 100 when restored...

Why would...

This line in the WHERE clause

AND (hrxoreturn.returndate >= '2023-02-14 00:00:00' and hrxoreturn.returndate <= '2023-02-14 23:59:00')

changes your RIGHT JOIN to an INNER JOIN.  If you move the line to your JOIN...

Have a look into the DATEPART function.  That should point you in the right direction.

I'm glad to hear that you've found a solution.  As far as synchronising data during migrations, replication or log-shipping (one way or the other) are probably the most straightforward options. ...

If you have access to the log files taken using Commvault, why can't you use some homegrown method to restore those to your target database?  We use the OH scripts...

There appears to be a typo in the question in that it asks for "what command" but there are apparently two correct answers.  The answers have tick boxes which suggests...

Guess how my f$%^ing Saturday has started too.

Now it's Friday.  Mine started especially early too with a callout 45 minutes...

Cove

I can't speak about becoming full developers but we're currently in the process of migrating to AWS.  As part of this, I've found myself building Windows Failover Clusters and working...

One, please, always, despite this being a technical question, talk to someone in legal at your organization after you decide on a path forward.

Two, I've been studying this for...

.

Heh... mine has started off with a bit of a "well that sucks" factor.  Whole new time-keeping system where they want me to categorize virtually every aspect of...

• This reply was modified 3 years, 9 months ago by Neil Burton.