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...

What are your PKs? Are they integers or characters? You could have conflicts. Typically if you are merging things, you want GUIDs to minimize conflicts.

Depending on what you are bringing...

I'd follow Jason's advice. Without knowing if the I/O is saturated for those DBs, it's hard to know if changing disks around would help.

You might also reanalyze the access of...

Check the default trace in SQL Server 2005 (search default trace on this site)