Reinstall is all you can do. There are too many things touched in the registry, files, etc.

You can easily detach databases, uninstall, reinstall, and attach them again.

You're also going to change recovery when you start the server. Doesn't sound like a big deal until people are calling you constantly about how long the server takes to...

SSIS has an XML provider that should read from a URL. Or you can create a CLR component to do this.

It's not built into the server, nor should it be....

there used to be a couple from Microsoft, .Text I think, but not sure if it used sprocs.

Same for Diffs (as Gail mentioned). Just ignore the scheduling, they work around each other.

Do you have PAE enabled?

Is this 32 bit and 2005? You posted in a 2000 forum, please be aware of where you are posting. (moved).

http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx should help you.

Also, are the...

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