Honestly I wouldn't do this in T-sQL, at least not directly in the server. Do it in a package, contain it, use a proxy for Agent, and then start the...

I'm not sure you can do what you want. A view is like a table, it has one row per company (based on other data) or it doesn't.

You could do...

Create a domain or local user, assign no rights. By default, they should have very few rights on the domain. Meaning EVERYONE shouldn't be assigned any rights.

You can restrict this...

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!