What is your operating system and service pack level? What is your SQL Server version and service pack level? This error is not restricted to VMWare. There are some things...

Agreed. A $4-500 PC, especially for a smaller site, can certain server as a DC. This does require more administrative overhead for the domain admins, but that overhead may be...

ADAM provides a directory service in a way where the computer isn't a full-blown domain controller. However, by instituting ADAM you would be instituting a security infrastructure that differed from...

Here is the HP page for SQL Server 2000 sizing. There are several sizers available:

HP: Microsoft SQL Server 2000

If that's the way the app works and they won't support any other config, then you'll have to rely on DENY to restrict access through another user defined database role....

Aye, sp_MSforeachdb is often used but it also uses cursors. So if you use it, you're still using cursors, it just looks cleaner.

Don't forget "Database Developer." A lot of "database developers" are what others would call "development DBAs."

If you want to re-use the password, then it is no different than data you are encrypting with respect to how to handle the encryption. In this particular case hashing...

Why does the public role have such access? Is this the way the 3rd party application set up permissions?

If not, create a user-defined database role and assign it the permissions...

If you want to go down this road, you're going to need to use an encryption algorithm which is a two-way function. Hashing functions won't do it for you, since...

I'm over-simplifying some things, but hopefully the gist is received.

When your client communicates to SQL Server, it passes your credential information over the TDS stream (the protocol SQL Server uses...

you can never go wrong listening to someone as smart as Brian Kelley!

Any chance you can convince my kids of this?

My faith does. When I tell folks that, some look at me funny. However, if I "do all things as unto the Lord," then that sets the standard for my...

Oops. Yup. AVG instead of SUM.

He wants not to return a column, but a value. We'd do something like this normally:

SELECT column, 'static value'
FROM table

To get the same result when you're building a string, you'll...