The feed we have here is missing an enclosure tag. We have that on the list to add, but it's not simple for a variety of reasons.

I don't have an...

Queries run within SQL Server. You call the query from your application, basically submitting the instruction to SQL like you might to Windows, and then SQL evaluates the query.

Communication...

Elizabeth has the best idea, but this can cause locks if you leave the transaction open.

So if you start with BEGIN TRAN, run the proc, and then start doing...

No real difference. In either scenario you could cause a page split, which would mean moving some portion of a page to a new page.

SQL allocates in extents and pages,...

BuiltIn/Administrators are the local administrators of the Windows OS. these are added to SQL Server so that those who administer the server can administer SQL.

The System is for service accounts.

IF you have clients with no SNAC, you might want to have them connect to an FQDN, something like sql.mydomain.com, with a short TTL. Then if you need to fail...

This sounds like homework or an interview question. Please make an attempt to show that you understand some of this.

Moved to 2005 forum.

If its just job ownership, you can set it to "Sa" and you should be fine.

It will not create accounts. You need to create them before installing.

If this is your workstation, just use your credentials, but be aware this can be a security issue.

You might do well checking out the T-SQL forums here, reading the first post and then trying to come up with an answer.

Have to go with failed backups since those end up getting us called back to work. Leaving the wife with the kids might be the scariest of all!

Thanks, question corrected. (and answer).

Add logging to the maintenance plan. the logging from the job isn't great (as you can see).

Is this db in simple mode?

You should right click Databases, select all tasks, then Attach. You should browse to your mdf files.