Unless you have an explicit need for guest, you should sp_revokedbaccess it from the databases in question. If someone doesn't have a valid user in a given database and the...

There are third-party tools that do it, but you might take a look at bcp. It's a command-line tool provided with SQL Server. Much faster than standard INSERTs.

There is a performance bug related to using the ODBC driver for SQL Server that showed up with SP3. Does this apply to your environment?

FIX: Performance...

Aha! The Information Schema views are only in master with SQL Server 2000. You can actually see this if you use the Object Browser in Query Analyzer. Expand views under...

If they have local Administrative rights, then likely the login corresponding to their Windows access is BUILTIN\Administrators. Assuming a default security setup, BUILTIN\Administrators is a member of the sysadmin fixed...

The Windows users, they wouldn't happen to be members of the local Administrators group on that system (Operating System) would they?

No, Windows permissions can't override SQL Server security. Are you saying you have SQL Server logins and have denied users access based on those SQL Server logins or you've applied...

Total Server Memory is the "total amount of dynamic memory the server is currently consuming."

Target Server Memory is the "total amount of dynamic memory the server is willing to consume."

True. Unless the owner is specified, it will be as the user who created them, meaning aliasing is pretty much it.

Okay, that's a bit different. You say it's choking all the network traffic and it's exposed to the Internet. When you get a...

The fixed database role db_ddladmin also has rights to create an object under the ownership of any user, to include dbo.

There are several easy ways:

Performance Monitor (Perfmon.exe)

- SQL Server:Memory Manager >> Total Server Memory (KB)

Using a tool like pslist.exe from SysInternals

Looking at Task Manager locally...

What error are you getting?

When you say all available IP addresses were taken, what was reporting that issue?

That is set when you choose to migrate the repository, so it could literally be anything. As for the access file, even after the repository is migrated I think the...