So it almost appears this is an assignment of some sort. We don't do homework for you. If you have a specific question, or you are wondering if there is...

I think Gail is like me, running from thing to thing, not sure how all the plates are staying in the air.

At least I have kids to balance things out...

I assume you can join the two tables and rows together.

The issue gets into permissions between databases. The user in DB 2 must have rights, or ownership chaining enabled, in...

Try this: http://www.sqlservercentral.com/scripts/Permissions/64309/

If it's a temp proc, it was created on your system. We have no way of knowing what it is.

You could try scripting it to see the code.

You can have both replication partners update data in merge or in bidrectional transactional replication. You need to really think through what to do if there are issues with conflicts...

Egg timer......:-P

If you won't need the space, yes, use shrink files, pick the log file.

Be sure you leave space in there for normal operation.

Bob,

I will for sure. I'll shoot for off hours.

Gus, we'll miss you. Next time.

Autoclose will actually write this in the error log for Windows. I don't see a trace event. Maybe capture any t-SQL batch in that db?

I have added the truncate item to the explanation.

My guess is it's the data you're returning.

If you have a loan in a table, say borrower, and you have two borrowers, what do you want done? Only the first...

Should be fine. Glad that worked.

I think that the problem was that you were using that database and when you clicked, it disconnected you. Your session went, and that included...

Hey, if it could kill my SPID, I might be way more productive!!?!? :-D:w00t:

Who has one machine?

If you have one machine, Backup is great.