Thanks to Tony for an attempted fix. I agree with Hugo that there are possibly answers that might change this. Therefore, I have reworded to specifically ask CI + NCI....

We don't do homework questions. We are happy to help you figure things you, but you need to make an attempt to get some initial work done and show some...

I'd go start with the Double Take documentation and ask them initial questions.

If the thread read funny, it is because I have removed NDA details about the exam from some posts.

Objects can't cross filegroups, but if you have multiple files in your filegroup, it would be on more than one.

You can, but that's limited info. Doesn't tell you "what" changed. If it's soon enough, the default trace might help you.

does a musician lose skills if they stop playing for a year? Does a cabinet maker's skills diminish?

They do to some extent. A certain level of rust accumulates in your...

You can easily change a SELECT to an update.

SELECT a.ID, b.Test

from MyTable A

inner join MyOtherTable B

on a.ID = b.ID

where a.customer...

You can see which files are changed in the kb article for each SP/CU. You will see quite a few files have their sizes and versions updated.

I'm a little late, but I'll add my $0.02 in there.

For the most part I don't think tables, stored procedures, and certainly not columns, need a prefix. The code itself...

Looks like The Thread is alive and well. Good to be back and hoping everyone behaved over the last week.

I think that's correct. Just add that failover partner to the string and you should be OK

What were you doing? Is this on startup? Or after you've connected to a system? Have you tried connecting to different systems?

Hopefully it's not a problem with Windows.

Two things: can you change another services ( like SSIS) to Local System?

If that works, can you reboot and see if something is just...

How is the job running? Typically this isn't under a user account. When you run it interactively, the package runs under your account. Those credentials might not work when a...