I hadn't seen your post when I wrote the blog entry, so it's a nice coincidence. If you want to get everything in one query, you can query the sysusers...

In running some tests a few years ago, I did notice some degradation but never took it a step to actually measure how much. I don't think it was significant,...

Same domain? Other than OS, anything different between the two SQL Servers? Any corresponding Audit Failure errors in the Security event log (OS)?

With Firefox I have to go to the forums first, then QoD. Otherwise I don't show up as logged in. Mine likely has to do with my cookie settings, though,...

Map the user back up to a login by the SID. Then take a look at xp_loginfo. One of the columns tells you if it's a user or group.

You...

True, very true. However, you're still having to execute EncryptByCert and DecryptByCert on the column. Therefore, if the app hits the base tables directly, you can't make this change seamlessly....

To be honest, I'm not sure. I've not had to install any of the two, I just know they are two most mentioned. We typically handle our encryption at the...

This is one of the issues with application roles in SQL Server 2000. Once you set an application role for a connection, it cannot be undone. Since connection pooling relies...

SQL Server 2000 doesn't have any sort of built-in encryption, so there's no choice but to go with a 3rd party tool. With SQL Server 2005 if you have the...

You might take a look at Protegrity's DefianceDPS or App Sec Inc.'s dbEcrypt

I believe both of those are supposed to do so...

To get SQL up and running, yes. If the user accounts are switching domains, too, then the appropriate groups, etc. will need to be given permission. Having gone through this...

1. Also consider using IPSEC policies to limit communications from the Internet to only the TCP port for SQL Server.

2. If you meant the SQL Server Listener service, no, it...

Are any of the servers clustered? If so, there are some changes on the cluster, replication or not.

With replication, you'll need to ensure that the new service accounts have the...

I'm not sure I understand what you're asking, Greg, but I'll take a stab...

If you're changing the application, as long as the application can encrypt/decrypt using the same mechanism and...

If I understand your problem right, the SQL Server Agent is pointing to a server other than the one it is installed with. If that's the case, in Enterprise Manager,...