I'm not clear what's an invalid record that doesn't get caught. You aren't checking for xact_state = 0, which is a valid value.

The way you're doing this isn't what I'd...

I say I work with computers, or maybe software. No need to go into more detail unless someone actually knows something about them and asks a more detailed question.

A couple things.

First, replication isn't a high level thing. It works by copying over transactions from the publisher to the subscriber, which can be your production and test environments, respectively....

If it is truly a master package, I might follow the advice above. If it's an 11th package that needs execution, you could create a 12th package that manages everything...

I might ignore it. He or she is either a troll, thinking that everyone should automatically...

The IP doesn't matter. SQL tends to work by name, and that's what's important. SQL Server tends to listen on all IPs that the server has configured.

That gets translated to...

In AdventureWorks, this will return the oldest record:

SELECT cc.CreditCardID, cc.CardNumber, cc.ModifiedDate

FROM Sales.CreditCard cc

WHERE cc.ModifiedDate = (SELECT MIN(ModifiedDate)

...

SSRS should do this, setting up reports, but that might be a lot of work. However it does subscriptions in the Enterprise edition.

Failing that, are you looking to generate the...

Robocopy may work. I used it years ago, but I believe it worked for just this kind of work.

There are lots of options these days in the cloud, but for...

OK, so to get a list of tables that are older than that date, this works:

SELECT name

FROM sys.objects

WHERE type = 'u'

AND create_date...

Nevyn is correct, it's hard to understand what you need. The description you've given isn't that clear as to what is needed.

You can mock up the table, but please give...

Enjoy presenting. Couple things.

1. Breathe. Easy to race through things. Take a moment at a few spots to get a drink of water or take a deep breath and pace...

Chris,

you'd have to remind me which VAS post, but I do think that we could use more articles that push this more complex information out to people to help them...

I don't have mugs or much swag at all anymore....

It sounds like you have thought things through well and I'd go with your gut.

re: mirroring: it's mostly a load of transactions issue. You can mirror 100 databases on x86...